Excel Shortcut Keys: Essential Commands and How to Use Them

In Microsoft Excel for Microsoft 365 on Windows, shortcut keys let you edit cells, move around a worksheet, format data, and manage files without repeatedly reaching for the ribbon. The most useful starting points are Ctrl+C and Ctrl+V for copying and pasting, Ctrl+Z to undo, Ctrl+S to save, Ctrl+Arrow keys to navigate through data, and Ctrl+1 to open Format Cells.

What Excel shortcut keys do

A keyboard shortcut is a key or combination of keys that performs an Excel command. Some shortcuts work anywhere in a workbook, while others depend on what is selected or whether you are editing a cell. For example, pressing Ctrl+C copies a selection; pressing F2 edits the active cell; and pressing Ctrl+Shift+L toggles filters for a data range.

Shortcuts are useful because they reduce repeated mouse movement, but they are not a separate way of working that you must learn all at once. You can use a shortcut for one frequent task and still use the ribbon, menus, or context menu for everything else. Excel also displays many commands in its ribbon menus, so a command can often be found even if you do not remember its key combination.

Ctrl means the Control key on a Windows keyboard. A plus sign means to hold the first key while pressing the next one.
Shift usually changes a command from acting on one cell or item to selecting a range, or produces a capital or alternate symbol.
Alt can activate ribbon Key Tips, which show the keys to press to reach commands in the ribbon.

Essential shortcuts for everyday work

These are practical first shortcuts to learn. They apply to Excel for Microsoft 365 on Windows unless noted otherwise.

Ctrl+C, Ctrl+X, Ctrl+V: copy, cut, and paste the selected cells or content.
Ctrl+Z: undo the most recent action. Ctrl+Y redoes an undone action, and in some situations repeats the last command.
Ctrl+S: save the workbook. For a new workbook, Excel may ask you to choose a name and location.
Ctrl+F: find text or values. Ctrl+H opens Find and Replace.
Ctrl+P: open the print screen, where you can review print settings and preview pages.
Ctrl+1: open the Format Cells dialog for the current selection.
Ctrl+T: turn a selected data range into an Excel table. Check the detected range and whether the first row contains headers before confirming.
Alt+=: insert an AutoSum formula, typically summing nearby numbers.

For example, if you have entered a value incorrectly, Ctrl+Z can undo the entry. If you later decide that the undo was a mistake, Ctrl+Y can redo it. Save regularly with Ctrl+S, especially before making a large set of changes or closing a workbook.

Moving around and selecting cells

Navigation shortcuts are especially helpful in long worksheets. The arrow keys move one cell at a time. Ctrl+Arrow moves to the edge of a continuous block of data in that direction; if the adjacent cell is blank, Excel moves to the next occupied edge or the worksheet boundary, depending on the layout. This makes Ctrl+Arrow useful for jumping through a filled column or row.

Home: move to the first column of the current row.
Ctrl+Home: go to the beginning of the worksheet, usually cell A1.
Ctrl+End: go to the last cell Excel considers used in the worksheet. Formatting or past content can make this cell farther down or across than the visible data.
Ctrl+Shift+Arrow: extend the selection from the active cell to the edge of a continuous data region.
Ctrl+Space: select the entire column; Shift+Space selects the entire row.
Ctrl+Page Up and Ctrl+Page Down: move to the previous or next worksheet tab.

Suppose column B contains names in B2:B500 with no blank cells in between. Click B2 and press Ctrl+Shift+Down to select through the end of that contiguous block. If there is a blank cell in the middle, the selection stops at the edge of the current block. In that case, use the mouse, the Name Box, or additional keyboard navigation to select the range you actually need.

Entering, editing, and filling data

Press F2 to edit the contents of the active cell. This is useful for changing part of a long entry without replacing the whole cell. Press Enter to confirm an edit, or Esc to cancel the edit in progress. When you are entering a value, Tab confirms it and moves to the cell on the right.

Several shortcuts help when entering repeated or structured information:

Ctrl+Enter: enter the same typed content into all cells in a selected range. Select the cells, type the entry, and press Ctrl+Enter rather than Enter.
Alt+Enter: insert a line break within a cell while editing its content. The cell may need Wrap Text enabled to display the lines clearly.
Ctrl+;: enter the current date as a value in the active cell. It does not update automatically tomorrow.
Ctrl+Shift+;: enter the current time as a value.
Ctrl+-: open the Delete dialog for selected cells, rows, or columns. The available choices depend on the selection.

There is an important distinction between entering a value and creating a live date or time. Ctrl+; inserts a date value at that moment; it is not a formula that recalculates as the calendar changes. If you need a date that updates automatically, use an appropriate worksheet formula instead, after considering whether a changing date is suitable for your recordkeeping.

Formatting numbers and worksheets

Use Ctrl+1 when you need more control over how cells appear. The Format Cells dialog includes number formats, alignment, font, borders, and fill options. Formatting changes how a value is displayed; it does not necessarily change the underlying value. For instance, a percentage format can display a stored value of 0.25 as 25%.

Some number-format shortcuts apply a common format directly:

Ctrl+Shift+1: apply a number format with two decimal places and a thousands separator.
Ctrl+Shift+4: apply a currency format.
Ctrl+Shift+5: apply a percentage format.
Ctrl+Shift+~: apply the General number format.

Check the displayed result after using a format shortcut. A currency format may use a currency symbol based on the workbook or regional settings, and percentage formatting changes the display by scaling the shown value. If a number appears unexpectedly, Ctrl+1 lets you inspect the selected cells’ number format.

For a formatted data list, Ctrl+T creates a table with built-in filtering and consistent formatting options. To enable or disable AutoFilter for a range, use Ctrl+Shift+L. A table and a filtered range are related but not identical: a table includes additional structured features, while AutoFilter can be applied to a regular range.

Shortcuts for formulas and calculations

Excel shortcuts can make formula entry quicker, but they do not replace checking the formula’s references and result. Use Alt+= to suggest an AutoSum formula next to or below a block of numbers. Excel selects a likely range; review the highlighted cells before pressing Enter, because blank rows or nearby values can affect what it proposes.

When writing a formula that refers to a cell, press F4 while the reference is selected in the formula bar or during formula entry to cycle through relative and absolute reference styles. For example, a reference such as A1 can be changed to $A$1, which keeps both the row and column fixed when the formula is copied. F4 behavior depends on the current context, and on some laptops you may need to use the Fn key with function keys.

Ctrl+` toggles the display of formulas in place of calculated results in a worksheet. The grave accent key is commonly near the upper-left area of a US keyboard, but its location and typing method can differ by keyboard layout. This view can help inspect formulas across a sheet; use the same shortcut again to return to normal results.

Windows, Mac, and Excel for the web

This guide gives Windows desktop shortcuts. In Excel for Mac, many common commands use Command instead of Ctrl: for example, Command+C and Command+V are the familiar copy and paste commands. However, not every Windows shortcut has a direct Command-for-Ctrl substitution. Function keys, navigation commands, and shortcuts that interact with macOS may differ, so check Excel’s menus or the shortcut information for the Mac version when a combination does not work.

Excel for the web runs inside a browser, and some keyboard combinations can be intercepted by the browser or operating system. Shortcuts may also differ from desktop Excel. If a key combination opens a browser feature instead of an Excel command, look for the command in the ribbon or consult the web app’s shortcut list. A Windows keyboard connected to a Mac, or a non-US keyboard layout, can also change which physical key produces a symbol such as the grave accent or plus sign.

Ribbon Key Tips are a useful Windows alternative when you know where a command lives but not its shortcut. Press Alt to display letters over ribbon tabs and commands, then press the displayed keys in sequence. These are not necessarily universal fixed combinations: the letters shown can depend on the current ribbon and interface language.

Common shortcut problems and how to fix them

If a shortcut appears not to work, first check whether Excel is editing a cell, whether the intended worksheet or range is active, and whether another program has focus. The same key can behave differently while editing a formula than it does while a cell is selected. Press Esc once to leave an edit or dismiss a selection state, then try again.

A shortcut types a symbol instead: check whether you are holding the right modifier keys and whether your keyboard layout changes the required key combination.
Ctrl+End lands far beyond your data: Excel may remember formatting or former content in distant cells. Inspect the area, remove genuinely unnecessary content or formatting if appropriate, save, and reopen the workbook to see whether the used range updates.
Ctrl+Arrow stops too early: a blank cell may split the data into separate regions. Navigate past the blank or select the desired range by another method.
A shortcut works in desktop Excel but not in a browser: the browser may reserve that combination, or the web version may use a different shortcut. Use the ribbon command as a fallback.
An action cannot be undone: some operations, such as running a macro, may not be reversible with Ctrl+Z. Save a copy before actions that could make broad changes.

Do not assume that every shortcut is safe simply because it is quick. A selection shortcut can include more rows or columns than expected, and Delete or formatting commands can affect the entire selection. Before applying a change to a large range, confirm the selection in the worksheet and use Undo promptly if the result is wrong.

How to learn and choose shortcuts

The most effective approach is to learn a small set that matches your repeated tasks. Someone who cleans lists may benefit most from navigation, selection, Find, and filtering shortcuts. Someone who builds reports may use formatting, worksheet navigation, and saving more often. There is no need to memorize every command before shortcuts become useful.

Choose one task you perform often, such as finding a value or moving between sheets.
Use the shortcut each time you perform that task for a few days, while keeping the ribbon command available as a backup.
Add a related shortcut only after the first one feels familiar, such as learning Ctrl+H after Ctrl+F.
Keep a short reference list near your workspace, and note whether it is for Windows, Mac, or the web version.

It is also reasonable to prefer the mouse for commands used rarely or for options that require visual inspection. Shortcuts are a convenience, not a requirement, and the best one is the command that is both quick and clear for the task at hand.

Frequently Asked Questions

What is the shortcut key to save an Excel file?

In Excel for Microsoft 365 on Windows, press Ctrl+S to save the current workbook. If it has not been saved before, Excel asks you to choose a file name and location.

How do I undo or redo in Excel?

Press Ctrl+Z to undo the last action and Ctrl+Y to redo an action that you undid. Some actions cannot be reversed through the normal Undo history, so save a copy before making changes that may be difficult to recover.

What shortcut selects all data in Excel?

Ctrl+A selects the current data region in many worksheet situations; pressing it again can expand the selection, such as to the whole worksheet. The exact selection depends on the active cell and whether you are working inside a table or another structured range.

How do I insert today’s date with a shortcut?

In Windows desktop Excel, press Ctrl+; to enter the current date in the active cell. It inserts a fixed date value rather than a date that updates automatically.

Do Excel shortcuts work the same on Mac?

Not always. Many familiar editing commands use Command on Mac instead of Ctrl, but navigation, function-key, and system-related shortcuts can differ. Check Excel’s menus or Mac-specific shortcut guidance if a Windows combination does not work.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.