There is no single, short list of every Microsoft Excel keyboard shortcut: available commands vary by operating system, Excel version, and what is selected. For Excel for Microsoft 365 on Windows, the shortcuts below cover the most useful everyday actions, with notes on Mac and web differences and ways to find the complete, current list for your setup.
Why there is no one universal shortcut list
Excel shortcuts are context-sensitive. A key can do one thing in a worksheet, another in a dialog box, and something else while editing a formula. Ribbon commands can also have keyboard sequences that depend on the selected tab, while some shortcuts are intercepted by Windows, macOS, or a web browser. Add differences between desktop and web editions, and a printed list cannot reliably represent every available command for every user.
The shortcuts in this guide refer primarily to the Windows desktop version of Microsoft Excel for Microsoft 365. Some work in older desktop releases too, but Microsoft can change features and shortcut behavior. In Excel for the web, browser key assignments and the browser itself can affect what works. On a Mac, many commands use Command instead of Ctrl, but that is not a universal substitution: some keys and combinations differ, so check the Mac-specific shortcut reference.
To see the latest shortcuts for your version, use Excel’s built-in help or Microsoft’s Excel keyboard shortcuts reference. In Excel for the web, look for the keyboard shortcuts help option in the Help area. If a command does not behave as expected, first check whether you are using Windows, Mac, or the browser edition and whether the cell is being edited.
Essential workbook and editing shortcuts
These commands help with routine file handling and correcting work. In the Windows desktop app, use:
Ctrl+Nto create a new workbook,Ctrl+Oto open one, andCtrl+Sto save.Ctrl+Pto open the print screen, andCtrl+Wto close the current workbook window.Ctrl+Zto undo andCtrl+Yto redo an action.Ctrl+C,Ctrl+X, andCtrl+Vto copy, cut, and paste the selection.Ctrl+Fto find andCtrl+Hto find and replace.F4to repeat the last eligible action in many situations. While editing a formula reference, it cycles through relative and absolute reference styles, such as A1, $A$1, A$1, and $A1.
Undo and redo are useful, but they are not a guarantee that every action can be reversed. For example, running a VBA macro cannot be undone with Ctrl+Z. Save an important workbook before running a macro or making a large, hard-to-reverse change.
Move around a worksheet and select cells
Navigation shortcuts are especially useful in large sheets. The arrow keys move one cell at a time. Ctrl+Arrow key jumps to the edge of a data region or to the next boundary in that direction; gaps in the data can change where it stops. Ctrl+Home moves to the beginning of the worksheet, usually cell A1, and Ctrl+End moves to the last cell Excel considers used. That last cell may be beyond the visible data if formatting or earlier edits extended the used range.
- Hold
Shiftwhile moving to extend a selection. For example,Ctrl+Shift+Down Arrowextends the selection to the edge of a data region. Ctrl+Spaceselects a column, andShift+Spaceselects a row.Ctrl+Aselects the current data region; pressing it again can expand the selection, depending on where the active cell is.F5orCtrl+Gopens Go To, where you can enter a cell address such as D250 or a named range.Alt+Enterinserts a line break within a cell while you are entering or editing its contents.
For example, to inspect a long list, click a cell in the list and press Ctrl+Down Arrow to move to the next boundary. If the column contains blank cells, the shortcut may stop at a blank or continue from it differently than expected. Use Ctrl+G when you know the destination address and want to avoid navigating through gaps.
Enter, edit, and fill data
Press F2 to edit the active cell in place. Press Enter to commit an entry, or Esc to cancel the current edit. The behavior of Enter after a cell is committed can depend on Excel’s settings, including the direction in which the selection moves.
For repeated values or formulas, these shortcuts can save time:
Ctrl+Dfills down from the top cell of a selected range;Ctrl+Rfills right from the leftmost cell.Ctrl+Enterenters the same typed value or formula into every cell in a selected range.Ctrl+Einvokes Flash Fill when Excel can recognize a pattern from nearby examples. Review the results, since pattern recognition may not match the intended rule.Ctrl+;enters the current date as a fixed value.Ctrl+Shift+;enters the current time as a fixed value.
For instance, if a column has a formula in its first selected cell, select that cell and the cells below it, then use Ctrl+D to copy the formula down. Excel adjusts relative references as it fills. Check the first and last results when the range includes blank rows or mixed formulas.
Format cells, tables, and data
Ctrl+1 opens the Format Cells dialog, which includes number formats, alignment, fonts, borders, and protection settings. It is often more dependable than memorizing a separate key combination for every display format. A few commonly used number-format shortcuts are:
Ctrl+Shift+~for the General number format.Ctrl+Shift+$for a currency format, andCtrl+Shift+%for a percentage format.Ctrl+Shift+#for a date format andCtrl+Shift+@for a time format.Ctrl+Shift+!for a number format with two decimal places and a thousands separator.
Keyboard layouts can affect how these symbol combinations are typed, so use Ctrl+1 if a format shortcut is awkward on your keyboard. Ctrl+B, Ctrl+I, and Ctrl+U toggle bold, italic, and underline. Ctrl+Shift+L toggles filters for a data range; it does not itself sort the rows. To create an Excel table from a data range, use Ctrl+T and confirm the range and whether it has headers.
When a shortcut changes the appearance of values, it usually changes their display format, not the underlying value. Formatting 0.25 as a percentage displays 25%, but the stored value remains 0.25. This distinction matters when copying data or checking calculations.
Formulas, calculations, and charts
Use Alt+= to insert an AutoSum formula in a suitable location. Excel proposes a range, which you should check before pressing Enter; nearby numbers above or beside the active cell are not always the numbers you intend to add. Ctrl+` toggles between displaying formulas and their calculated results in the worksheet. The grave-accent key’s location varies by keyboard layout.
While typing a formula, use F4 after selecting or entering a cell reference to change its reference style. For example, a relative reference such as A1 can be made absolute as $A$1, which stays fixed when a formula is copied. Mixed references lock only a row or column. This shortcut is most useful when building formulas to fill across or down; it does not alter the calculated value by itself.
To make a chart from selected data, Alt+F1 inserts a chart in the current worksheet, while F11 creates a chart sheet in desktop Excel. The chart type and layout may be chosen automatically, so inspect the result and adjust it if needed. For a quick illustration, select a small table with month labels and sales totals before invoking a chart shortcut; selecting only the totals may produce a chart without useful category labels.
Work with sheets, rows, columns, and cells
Shift+F11 inserts a new worksheet. Use Ctrl+Page Up and Ctrl+Page Down to move between worksheet tabs in the workbook. These combinations can be convenient in a workbook with many sheets, but they do not move between separate workbook windows.
For structural changes, Ctrl+Shift++ opens the Insert dialog for cells, rows, or columns, depending on the selection. Ctrl+- opens the Delete dialog. Select a full row or column first if that is what you intend to insert or remove. Deleting cells can shift surrounding data, so check the selected range before confirming. These shortcuts are different from clearing cell contents, which leaves the cells in place.
Some ribbon commands have access-key sequences rather than a single shortcut. Press Alt in Windows desktop Excel to show the available Key Tips, then follow the letters displayed on the ribbon. The letters can vary with the interface language and version. This is a practical way to reach commands for which you do not remember a direct shortcut, without guessing at a sequence.
Windows, Mac, and Excel for the web
Many Mac shortcuts use Command where Windows uses Ctrl; for example, common file and clipboard commands generally follow that pattern. But do not assume every Windows shortcut becomes identical by replacing Ctrl with Command. Mac keyboards have different function-key behavior, and some combinations use Option, Control, or different keys. Consult the Excel for Mac shortcut list for the particular action you need.
Excel for the web runs inside a browser, so browser shortcuts can conflict with spreadsheet commands. Some desktop features and key combinations also work differently online. If you need to edit a workbook in a browser and a shortcut is intercepted, use the ribbon or the web app’s keyboard-shortcut help rather than assuming the desktop sequence is supported. The same workbook may therefore have different practical shortcuts depending on where it is open.
Assistive technology, keyboard layout, and regional settings can also affect key combinations. If a symbol-based shortcut does not work, check the physical key that produces the symbol on your layout. If Excel is editing a cell rather than selecting it, first commit or cancel the edit; many navigation shortcuts behave differently while the insertion point is inside cell text.
How to learn and troubleshoot shortcuts
Trying to memorize a giant list is rarely necessary. Start with actions you repeat, then add a few shortcuts at a time. A useful learning sequence is:
- Learn selection and navigation, such as
Ctrl+Arrow,Ctrl+Home, andCtrl+G. - Add editing and recovery keys, including
F2,Ctrl+Z, andCtrl+Y. - Practice the formatting and data commands you use often, such as
Ctrl+1,Ctrl+T, andCtrl+Shift+L. - Use Key Tips or Excel help to discover less familiar ribbon commands in your own installation.
When a combination fails, confirm the app, operating system, keyboard layout, and selection context. Also check whether the key is being used by a laptop’s function-key layer or an accessibility tool. For consequential changes, understand what a shortcut will affect before pressing it: a delete command on a selected column is much broader than clearing one cell.
Frequently Asked Questions
Is there a shortcut to see all Excel shortcuts?
There is not one universal shortcut that displays every shortcut for all Excel versions. Pressing Alt in Windows desktop Excel reveals Key Tips for ribbon commands. For a broader list, use Excel’s keyboard-shortcut help or the official shortcut reference for your platform.
What is the shortcut to select all cells in Excel?
Use Ctrl+A in Windows. Depending on the active cell and whether the data is in a table or region, the first press may select the current data area and another press may expand the selection. To select a whole worksheet directly, click the Select All button at the intersection of the row and column headings.
What is the shortcut to switch worksheets?
In Windows desktop Excel, use Ctrl+Page Up for the previous sheet and Ctrl+Page Down for the next sheet. Mac key combinations differ; check the Mac reference rather than assuming the Windows keys will translate directly.
Why does Ctrl+E not fill my data?Ctrl+E runs Flash Fill, which attempts to infer a pattern from examples; it is not a general-purpose fill command. Provide clear examples in adjacent cells and review the generated values. Use Ctrl+D or Ctrl+R to copy a value or formula down or right instead.
Do Excel shortcuts work the same on Mac and in a browser?
No. Many Mac commands use Command instead of Ctrl, but there are exceptions. In Excel for the web, browser conflicts and feature differences can also change behavior. Check the shortcut help for the version you are using, or use the ribbon when a key combination is unavailable.
Related
- Excel Merge Multiple Cells Into One Cell: A Clear Guide
- Excel Merge Two Cells Into One Cell Without Losing Text
- Excel: Merge Data From Multiple Cells Into One Cell
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- IFERROR in Google Sheets: Meaning and How to Use ItIn Google Sheets, IFERROR checks whether a formula produces an error and lets you show a different value…
- How to Make Two Columns in Microsoft Word: A GuideTo make two columns in Microsoft Word for Microsoft 365 on Windows, open the Layout tab, choose Columns,…
- Change Indent in Word Online: Steps, Tips, and FixesTo change an indent in Word Online, select the paragraph or paragraphs, then choose Home > Increase Indent…
- Keep the Home Tab Open in Excel: Show the RibbonTo keep Excel’s Home tab visible, expand the ribbon, choose the option to always show it, and click…
- Sort Dates in Google Sheets: A Step-by-Step GuideTo sort data by date in Google Sheets, select the entire table, open Data > Sort range >…
- Excel Import CSV Without Formatting: Keep Data RawTo import a CSV into Excel without unwanted formatting, use Data > From Text/CSV, choose Transform Data, set…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.