For Excel for Microsoft 365 on Windows, some of the most useful keyboard shortcuts are Ctrl+C to copy, Ctrl+V to paste, Ctrl+Z to undo, Ctrl+S to save, Ctrl+Arrow to move to the edge of a data region, and Ctrl+Shift+Arrow to select to that edge. Excel has many more shortcuts for editing cells, formatting values, working with formulas, and moving between worksheets; on a Mac, common commands usually use Command instead of Ctrl, though not every shortcut translates directly.
Essential Excel shortcuts for everyday work
Shortcuts reduce the need to move between the keyboard and ribbon, especially for actions repeated many times. These Windows combinations work in the Excel desktop app unless a particular context or another program intercepts them.
- Ctrl+C, Ctrl+X, and Ctrl+V: copy, cut, and paste the selected cells or content.
- Ctrl+Z and Ctrl+Y: undo and redo or repeat an action, where supported.
- Ctrl+S: save the workbook. In a new workbook, Excel may ask you to choose a name and location.
- Ctrl+F and Ctrl+H: open Find and Replace.
- Ctrl+P: open the print view and printing options.
- Ctrl+1: open the Format Cells dialog for the selected cells.
These combinations are useful starting points, but Excel shortcuts often depend on what is active. For example, Ctrl+C copies selected cells, while pressing it during text editing copies selected text. If a shortcut appears to do nothing, first check whether the cell, worksheet, dialog, or formula bar has focus.
Moving around a worksheet
Navigation shortcuts are especially helpful in large sheets. The arrow keys move one cell at a time. With Ctrl held down, an arrow key moves to the edge of the current contiguous data region, or to the next occupied cell or worksheet boundary when the path includes blanks. This is not always the same as jumping to the final row of the worksheet: empty cells can change where the shortcut stops.
- Ctrl+Home: move to the beginning of the worksheet, normally cell A1.
- Ctrl+End: move to the last cell Excel considers used. This may be farther down or to the right than the visible data if old formatting or edits extended the used area.
- Ctrl+Page Up and Ctrl+Page Down: move to the previous or next worksheet tab.
- Page Up and Page Down: scroll the worksheet view vertically by a screenful.
- Alt+Page Up and Alt+Page Down: scroll horizontally by a screenful.
For example, if a list fills cells A1:D500 with no blank rows, selecting A2 and pressing Ctrl+Down moves to the bottom of that continuous block. If row 120 is blank, the shortcut stops at the edge of the current block instead. To move to a specific cell, press Ctrl+G to open Go To, type a reference such as D250, and press Enter.
Selecting cells, rows, and columns
Selection shortcuts let you apply formatting, copy a range, or inspect data without dragging across the grid. Start from a cell in or next to the area you want, then use the appropriate combination. Selection behavior depends on the active cell and whether the data is continuous.
- Ctrl+Shift+Arrow: extend the selection to the edge of the data region in that direction.
- Ctrl+A: select the current data region; pressing it again can select the entire worksheet, depending on the active cell and context.
- Ctrl+Space: select the entire column containing the active cell.
- Shift+Space: select the entire row containing the active cell.
- Shift+Arrow: extend the selection by one cell in the chosen direction.
To select a full table quickly, click a cell within it and use Ctrl+A. In a structured Excel table, the first press may select the table’s data area and another press can expand the selection. Check the highlighted area before deleting or overwriting anything; a shortcut can select more than the visible portion of a long range.
Entering and editing cell contents
Press F2 to edit the active cell’s contents in place. It is often faster than double-clicking a cell, and it helps avoid replacing a value accidentally when you meant to change part of it. Press Enter to commit an entry, or Esc to cancel the current edit. Press Alt+Enter while editing a cell to insert a line break within that cell rather than moving to another one.
Other useful editing shortcuts include Delete to clear the contents of selected cells without removing the cells themselves, and Ctrl+D or Ctrl+R to fill down or fill right from the top row or leftmost column of a selected range. For example, enter a formula in B2, select B2:B20, and press Ctrl+D to copy it down the selection. Excel adjusts relative references as it fills, just as it does when you drag the fill handle.
F4 has two common uses. While editing a formula reference, it cycles through relative and absolute reference forms, such as A1, $A$1, A$1, and $A1. Outside that situation, it can repeat the last action in contexts where Excel supports repeating it. Because the effect depends on what you are doing, read the formula or check the result after pressing it.
Formatting numbers and cells with keys
Formatting shortcuts change how values appear; they do not usually change the underlying value. For example, applying a percentage format to 0.25 displays 25%, while the stored number remains 0.25. Use Ctrl+1 when you need more control over number formats, alignment, borders, or other cell settings.
- Ctrl+Shift+~: apply the General number format.
- Ctrl+Shift+!: apply a number format with two decimal places and a thousands separator.
- Ctrl+Shift+$: apply a currency format.
- Ctrl+Shift+%: apply a percentage format with no decimal places.
- Ctrl+Shift+#: apply a date format.
- Ctrl+Shift+@: apply a time format.
- Ctrl+B, Ctrl+I, and Ctrl+U: toggle bold, italic, and underline.
Some symbols on these combinations vary with keyboard layout, and the displayed date or currency style can depend on regional settings. If a number seems to have changed unexpectedly, select the cell and look at the formula bar: a different display format is not necessarily a different value. To remove a format, use the options under Home > Clear rather than deleting the cell’s contents.
Shortcuts for formulas, dates, and data tools
Alt+= inserts an AutoSum formula in an appropriate location, usually suggesting a range of adjacent numbers. Review the suggested range before accepting it, especially if there are blank rows or unrelated values nearby. The shortcut helps create a formula; it does not verify that the selected numbers are the ones you intended to total.
To enter fixed date or time values, use Ctrl+; for the current date and Ctrl+Shift+: for the current time on Windows. These insert values into the selected cell; they are not live functions that update continuously. By contrast, a formula such as TODAY() recalculates according to Excel’s calculation behavior. This distinction matters for a timestamp that should remain as originally entered.
For common data tasks, Ctrl+T turns a selected range into an Excel table and opens a confirmation dialog where appropriate. Ctrl+Shift+L toggles filter buttons for a range. Ctrl+E starts Flash Fill, which can infer a pattern from examples, such as separating first names from full names. Always inspect Flash Fill’s output: it fills values based on a pattern rather than creating a formula that stays linked to the source data.
Press Ctrl+` (the grave-accent key, usually near the upper-left corner of a US keyboard) to toggle between showing formulas and showing their calculated results. This is useful when checking a worksheet, but the key’s location can differ on other keyboard layouts. Press it again to return to the normal view.
Using the ribbon without a mouse
Excel’s ribbon has keyboard navigation built in. Press Alt on Windows to display Key Tips, the small letters or key sequences shown over ribbon tabs and commands. Type the displayed sequence to open a tab or invoke a command. The letters can vary as the ribbon changes, so follow what appears on your screen rather than memorizing a sequence from a different installation.
This approach is useful when you know a command’s location but not its direct shortcut. For instance, you can use the displayed Key Tips to navigate to a ribbon command, then continue using the keyboard within its menus. Press Esc to back out of a menu or dismiss Key Tips. For command discovery, Excel’s Search box can also locate many commands by name; the exact shortcut for reaching Search can depend on the version and platform.
Windows, Mac, and Excel for the web differences
This guide focuses on Microsoft 365 Excel for Windows. On a Mac, common editing commands generally use Command for actions such as copy, paste, save, and undo, where Windows uses Ctrl. However, this is a useful starting rule, not a universal conversion: navigation, function-key, ribbon, and special-character shortcuts can differ. Some Mac keyboards require holding Fn to use function keys such as F2, depending on keyboard settings.
Excel for the web runs in a browser, so a browser or operating system may reserve some key combinations. If a shortcut opens a browser feature instead of performing an Excel action, use Excel’s menus or check Microsoft’s current shortcut list for the web app. A desktop keyboard sequence that relies on Windows ribbon Key Tips may not behave identically in the browser. When following instructions written for another platform, verify both the app and the operating system named in the instructions.
Choosing shortcuts and fixing common problems
You do not need to memorize every shortcut. Begin with actions you repeat—navigation, copy and paste, undo, saving, and formatting—and add specialized combinations when a task becomes routine. A small personal reference list near your workstation can be more useful than trying to learn a long catalog at once. Practicing a shortcut in a test workbook is sensible when it could affect a large selection.
- The shortcut triggers the wrong action: check whether Excel, a dialog box, or another program has focus, and confirm that the instructions match your operating system.
- Ctrl+End goes too far: Excel may include previously formatted cells in its used range. Check for leftover formatting or content beyond the visible data before deleting anything.
- A shortcut changes the display, not the value: number-format shortcuts typically alter presentation. Inspect the formula bar or use Format Cells to confirm the underlying value.
- Ctrl+Arrow stops early: blank cells divide data into separate regions. Move past the blank or use Go To to reach a known address.
- A key appears not to work on a laptop: function keys may share controls for brightness or volume. Try the keyboard’s Fn key or review its settings.
One common misconception is that keyboard shortcuts are identical across every version of Excel. Many core combinations are stable, but platform, keyboard layout, active context, and browser behavior can affect the result. Another is that a shortcut always performs the same action: F4 is a good example, because formula editing changes its role. If accuracy matters, pause to inspect the selected range and result before continuing.
Frequently Asked Questions
What is the shortcut for saving an Excel file?
Ctrl+S saves a workbook in Excel for Windows. On a Mac, use Command+S. If the workbook has not been saved before, Excel will ask where and under what name to save it.
How do I select an entire column or row in Excel?
Click a cell in the desired column and press Ctrl+Space to select the column. Press Shift+Space to select the active cell’s entire row on Windows.
How can I move quickly to the last used cell?
Press Ctrl+End. Excel moves to the last cell it considers used, which may include cells with old formatting or prior edits, not just the last cell containing visible data.
What is the shortcut to insert today’s date?
On Windows, press Ctrl+; in the cell where the date should go. It inserts a fixed date value, unlike a date formula that can recalculate later.
Why do Excel shortcuts differ on a Mac?
macOS and Excel for Mac use different key mappings for some commands, and function keys may require Fn. Many common commands use Command in place of Windows Ctrl, but check the shortcut for the specific command rather than assuming every key combination is interchangeable.
Related
- How to Turn Off Automatic Calculation in Excel 365
- How to Transpose Names in an Excel Column to a Row
- How to Transpose in Excel: Turn Rows Into Columns Easily
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Dropdown Lists: How They Work and How to Create ThemAn Excel dropdown list is a cell control that lets someone choose from a set of permitted entries…
- How to Eliminate Duplicates in Google Sheets QuicklyTo eliminate duplicates in Google Sheets, select the data range, then choose Data > Data cleanup > Remove…
- XLOOKUP in Google Sheets: How It Works and When to Use ItYes. Google Sheets supports XLOOKUP, so you can search one range for a value and return the corresponding…
- Excel Power Query Value Transformation: Types and StepsIn Excel, a Power Query value transformation changes or cleans data inside a query before it is loaded…
- Excel Shortcut to Expand a Column: AutoFit and MoreIn Excel for Microsoft 365 on Windows, select a cell in the column and press Alt, H, O,…
- Excel Column to Comma-Separated List: Easy MethodsIf your values are in A2:A20, enter =TEXTJOIN(", ",TRUE,A2:A20) in an empty cell to turn the column into…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.