Excel spreadsheet keyboard shortcuts let you move around a worksheet, select data, enter and edit values, format cells, and manage workbooks without reaching for the mouse. In Excel for Microsoft 365 on Windows, start with Ctrl+C and Ctrl+V for copying and pasting, Ctrl+Arrow keys for navigating data, F2 for editing a cell, and Ctrl+S for saving.
How Excel shortcuts work
A shortcut combines one or more keys to perform a command. Ctrl is the main modifier for many Excel shortcuts on Windows; Shift, Alt, and function keys such as F2 and F4 add other commands. The same key may do different things depending on whether you are typing in a cell, editing a formula, or using a dialog box. Excel’s status bar and ribbon can also show context-specific instructions.
Shortcuts are useful for repeated tasks, but you do not need to memorize a long list at once. Learn a few that fit your work, then add more as you encounter recurring actions. For example, someone cleaning a contact list may benefit more from selection and filtering shortcuts than from shortcuts for printing or chart formatting.
Unless noted otherwise, the Windows shortcuts below refer to Excel for Microsoft 365 desktop. Press the keys together when a combination is shown with a plus sign. A sequence such as Alt, H, O, I means press and release each key in order, rather than holding them all down together.
Essential workbook and editing shortcuts
These commands cover common workbook operations and the basic clipboard actions. They are a useful starting set for everyday spreadsheet work:
- Ctrl+N creates a new workbook, while Ctrl+O opens a workbook and Ctrl+S saves the current one.
- Ctrl+P opens the print screen, and Ctrl+W closes the current workbook window.
- Ctrl+C, Ctrl+X, and Ctrl+V copy, cut, and paste the current selection.
- Ctrl+Z undoes an action. Ctrl+Y redoes an undone action or repeats the last action when Excel supports it.
- Ctrl+F opens Find, and Ctrl+H opens Find and Replace.
- Ctrl+K opens the dialog for inserting or editing a hyperlink.
Saving with Ctrl+S is especially useful before substantial edits, importing data, or applying changes to many cells. Excel’s Undo command can reverse many ordinary worksheet actions, but it is not a substitute for saving a separate copy before a risky operation. Some actions, including running a macro, cannot be undone with Ctrl+Z.
Move around a worksheet quickly
Arrow keys move one cell at a time. When a sheet contains many rows or columns, these shortcuts can reduce long stretches of repeated tapping:
- Ctrl+Arrow key moves to the edge of the current continuous data region in that direction. If there is a blank cell between data, the stopping point may be the blank or the next data region.
- Ctrl+Home moves to the beginning of the worksheet, normally cell A1.
- Ctrl+End moves to the last cell Excel considers used. That can be farther than the visible data if cells were previously formatted or edited.
- Page Up and Page Down move the view up or down by about one screen. Alt+Page Up and Alt+Page Down move the view left or right by about one screen.
- Ctrl+Page Up and Ctrl+Page Down switch to the previous or next worksheet tab.
- F5 or Ctrl+G opens Go To, where you can enter a cell address such as D250 or a named range.
For a practical example, if a column of data runs from B2 to B500 with no blank cells, select B2 and press Ctrl+Down to reach the bottom of that continuous block. If the column has gaps, use Find, Go To, or the Name Box to reach a specific row instead of assuming Ctrl+Down will jump to the final record.
Select cells, rows, and columns
Many formatting and editing commands apply to a selection, so learning selection shortcuts can save more time than learning formatting commands alone. To extend a selection while moving, hold Shift with an arrow key. For larger data regions, use these combinations:
- Ctrl+Shift+Arrow key extends the selection to the edge of a continuous data region.
- Ctrl+Space selects the column containing the active cell.
- Shift+Space selects the active cell’s row.
- Ctrl+A selects the current data region in many worksheet contexts; pressing it again can expand the selection, such as to the entire worksheet.
- Ctrl+Shift+End extends the selection to the last used cell from the active cell.
Selection behavior depends on where the active cell is and whether the data is in a formatted Excel table. Check the highlighted range before deleting, clearing, or applying a broad format. This is particularly important after Ctrl+A, because selecting a table or data region is not always the same as selecting every cell on the sheet.
Enter and edit data efficiently
To change the contents of the active cell without replacing the whole entry, press F2. This places the insertion point in the cell’s contents, where you can edit text or a formula. Press Enter to confirm the edit, or Esc to cancel the current entry. If you begin typing without pressing F2, Excel replaces the existing cell contents.
Other useful entry and fill commands include:
- Alt+Enter inserts a line break within the current cell while you are editing it.
- Ctrl+Enter enters the same value or formula into all cells in a selected range. Select the range first, type the entry, then press Ctrl+Enter.
- Ctrl+D fills the top cell’s contents down through the selected range.
- Ctrl+R fills the leftmost cell’s contents to the right through the selected range.
- Ctrl+; inserts the current date as a value. Ctrl+Shift+; inserts the current time as a value.
For example, to put the same department name into A2:A20, select that range, type the name, and press Ctrl+Enter. To copy the formula in C2 into C3:C20, select C2:C20 and press Ctrl+D. Check that the selected cells are the intended destination before using a fill shortcut, because it can overwrite existing content.
Format cells and manage tables
Formatting shortcuts are most reliable after you select the intended cells. Ctrl+1 opens the Format Cells dialog, which includes number formats, alignment, font, borders, and fill options. Ctrl+B, Ctrl+I, and Ctrl+U toggle bold, italic, and underline.
For common number formats on a typical U.S. keyboard, Excel also provides Ctrl+Shift+~ for General, Ctrl+Shift+$ for Currency, and Ctrl+Shift+% for Percentage. These combinations may be inconvenient or differ with keyboard layouts and regional settings, so Ctrl+1 is a dependable alternative when a shortcut does not produce the expected format. Formatting changes how a value is displayed; it does not necessarily change the underlying value.
To turn a range into an Excel table, select a cell in the data and press Ctrl+T. Review the suggested range and the option indicating whether the table has headers before confirming. Press Ctrl+Shift+L to turn AutoFilter buttons on or off for a range. Tables add structured features such as filter controls and automatic expansion when adjacent data is added; they are different from merely applying color or borders.
Shortcuts for formulas and calculations
Excel has several shortcuts that help create or inspect formulas. Press Alt+= to insert an AutoSum formula for a nearby row or column of numbers. Excel guesses which cells to include, so inspect the proposed range before pressing Enter, particularly if blanks or labels interrupt the data.
While editing a formula, place the insertion point on a cell reference and press F4 to cycle through relative and absolute reference forms. For example, A1 can cycle through $A$1, A$1, and $A1. Absolute references are useful when copying a formula that should continue referring to a fixed input cell, such as a tax-rate assumption. F4 can also repeat the last eligible action when you are not editing a formula, so its effect depends on context.
Press Ctrl+` (Ctrl plus the grave-accent key, often located near the upper-left corner of a U.S. keyboard) to show or hide formulas in the worksheet instead of their calculated results. This is handy when reviewing a model or checking whether a column contains formulas. The key location varies across keyboards. If the shortcut is awkward, use the Formulas tab and the Show Formulas command.
Windows, Mac, and Excel for the web
Windows shortcuts do not all transfer literally to other platforms. In Excel for Mac, many common commands use Command in place of Windows Ctrl: for example, Command+C copies, Command+V pastes, Command+S saves, Command+Z undoes, and Command+F opens Find. Other shortcuts may use Option, Control, or function keys differently, and Mac keyboard settings can affect function-key behavior. Use Excel’s menus or shortcut help when a Windows combination does not work on a Mac.
Excel for the web runs inside a browser, so a browser may reserve or intercept some key combinations. Common editing shortcuts such as Ctrl+C and Ctrl+V usually remain familiar on Windows, but not every desktop command is available in the same way. Microsoft documents web-specific shortcuts, including the use of Alt+Windows logo key sequences to access ribbon key tips in supported Windows browsers. If a shortcut opens a browser feature rather than Excel, use the ribbon or check the current Excel for the web shortcut list.
When sharing instructions with colleagues, identify the platform as well as the shortcut. Saying “press Ctrl+1” is clear for Windows desktop Excel, but a Mac user may need a different key combination. The command itself, opening Format Cells, remains available from the interface even when the shortcut differs.
Common shortcut problems and fixes
A shortcut that seems broken may be working in a different context or may be affected by the keyboard, selection, or platform. Before changing Excel settings, check a few basics:
- Confirm the active window is Excel, not a browser, another application, or a dialog box that uses the same keys differently.
- Check whether you are editing inside a cell. Press Esc to cancel an unintended edit, or Enter to finish it, then try the shortcut again.
- For Ctrl+Arrow and Ctrl+Shift+Arrow, look for blank cells. A gap changes where Excel treats the edge of a continuous data region.
- On a laptop, check whether function keys require the Fn key or a change to the keyboard’s function-key setting.
- On a Mac or in a browser, look up the platform-specific version rather than assuming every Windows shortcut is identical.
Another common misconception is that Ctrl+End always goes to the last nonempty cell. It goes to Excel’s last used cell, which may reflect past formatting or edits. If it lands too far away, inspect the intervening area and remove unnecessary formatting or contents only after confirming they are not needed.
Frequently Asked Questions
What is the most useful Excel shortcut to learn first?
For many users, Ctrl+S is a good first choice because it saves the workbook. Ctrl+Z is another practical everyday shortcut, while Ctrl+Arrow and Ctrl+Shift+Arrow help most when navigating or selecting large blocks of data.
How do I edit a cell without deleting its contents?
Select the cell and press F2 on Windows. Excel places the cursor in the existing entry so you can change part of the text or formula. Press Enter to accept the edit or Esc to cancel it.
How do I select an entire row or column with the keyboard?
With a cell in the desired row active, press Shift+Space to select the row. Press Ctrl+Space to select its column. Check the highlight before applying a change that could affect many cells.
Why does Ctrl+Arrow stop before the end of my data?
Excel uses blank cells to determine the boundaries of a continuous data region. If a column contains a gap, Ctrl+Arrow can stop at that gap or move to another region. Use Go To with Ctrl+G to jump to a known cell address.
Do Excel keyboard shortcuts work the same on Mac?
No. Many common Mac commands use Command where Windows uses Ctrl, but other combinations differ and function-key settings can matter. For example, copying is Command+C on Mac and Ctrl+C on Windows. Check the Mac-specific shortcut for commands beyond the familiar basics.
Related
- Excel Sheet Keyboard Shortcuts: Essential Keys and Tips
- Excel Shopping List Template: Create, Organize, and Print
- Excel: Shade the Area Under a Curve
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel File Large for No Reason? Causes and Fixes to TryAn Excel file that seems far too large usually contains hidden formatting, an oversized used range, embedded objects,…
- Excel: How to Consolidate Multiple Rows Into One CellIf your goal is to combine values from matching rows into one cell, put the matching key in…
- Google Sheets Identify Duplicates: A Practical GuideYes. Google Sheets can identify duplicate values with conditional formatting or a COUNTIF formula, and it can remove…
- How to Schedule an Email in Outlook on Any Device TodayTo schedule an email in Outlook, write your message, open the menu beside Send, choose a scheduling option,…
- Create a Brochure in Microsoft Word: Layout, Steps and TipsTo create a brochure in Microsoft Word, start with a brochure template or set up a blank document…
- How to Insert a Coloured Line in Word on Any PageTo insert a coloured line in Word, choose Insert > Shapes > Line, draw the line, then select…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.