Microsoft Excel Shortcut Keys: Essential Commands

Microsoft Excel shortcut keys let you perform common actions from the keyboard instead of opening ribbon menus. In Excel for Microsoft 365 on Windows, start with Ctrl+C to copy, Ctrl+V to paste, Ctrl+Z to undo, and Ctrl+S to save; the sections below cover shortcuts for editing, navigation, selection, data, and formatting.

What Excel shortcut keys do

A shortcut is a key or key combination that runs an Excel command. Many use Ctrl plus a letter or symbol; others use function keys such as F2, or ribbon access keys that begin with Alt. A plus sign means to press the keys together, not one after another. For example, hold Ctrl while pressing C to copy.

Shortcuts can save time on repetitive work, but they are most useful when you know what they affect. Some commands depend on the active cell, the selected range, or whether the cursor is inside a table or editing a formula. If a key combination does something unexpected, check the selection and active window before assuming the shortcut is wrong.

These examples are for Excel for Microsoft 365 on Windows. Excel is regularly updated, and keyboard layouts, laptop function-key settings, and regional settings can affect how a key is pressed. Microsoft’s built-in shortcut reference and Excel’s ribbon KeyTips can help confirm commands on a particular setup.

Everyday shortcuts for editing and files

These are practical starting points for entering and managing worksheet content. They work in many other Windows applications too, which makes them easy to remember.

Ctrl+C, Ctrl+X, and Ctrl+V: copy, cut, and paste selected cells or content.
Ctrl+Z and Ctrl+Y: undo and redo an action. Redo may repeat the last action when there is nothing to redo, depending on the context.
Ctrl+S: save the workbook. For a new file, Excel may ask where to save it and what to name it.
Ctrl+N and Ctrl+O: create a new workbook and open an existing one.
Ctrl+P: open the print view, where you can review pages and print settings before printing.
Ctrl+F and Ctrl+H: find text or values, and open Find and Replace.
Esc: cancel many in-progress actions, close a menu, or stop editing without accepting the current entry.
F2: edit the active cell’s contents. Press Enter to commit the change or Esc to cancel it.

When entering the same value or formula into several selected cells, type it and press Ctrl+Enter to place the entry in all selected cells. This is different from pressing Enter, which normally commits an entry and moves the active cell. Select the intended range first: the command applies to every cell in that selection.

Move around a worksheet efficiently

Large sheets are easier to navigate with keyboard commands than by dragging scroll bars. The result of a movement shortcut depends on the content around the active cell, so it helps to try it on a small sample before using it in a complex selection.

Ctrl+Arrow key: move to the edge of the current data region in that direction. Blank cells can change where Excel stops.
Ctrl+Home: move to the beginning of the worksheet, usually cell A1.
Ctrl+End: move to the last cell Excel considers used. This may be beyond the visible data if formatting or previous entries extended the used range.
Page Up and Page Down: move one screen up or down. Alt+Page Up and Alt+Page Down move one screen left or right.
Ctrl+Page Up and Ctrl+Page Down: switch to the previous or next worksheet tab in the workbook.

For example, if a list is continuous from A2 to A200, selecting a cell in column A and pressing Ctrl+Down moves to the bottom of that uninterrupted block. If there is a blank row within the list, Excel may stop at the blank or at the next populated block. Use Ctrl+Home when you want a predictable return to the top-left rather than relying on the shape of the data.

Select cells, rows, and columns

Selection shortcuts are especially valuable before copying, formatting, or applying a command. Always check the highlighted range before making a change that could affect many cells.

Shift+Arrow key: extend the current selection by one cell in the chosen direction.
Ctrl+Shift+Arrow key: extend the selection toward the edge of the current data region. Gaps in the data affect the endpoint.
Ctrl+Space: select the entire column containing the active cell.
Shift+Space: select the entire row containing the active cell.
Ctrl+A: select the current data region in many worksheet contexts; pressing it again can expand the selection. Its behavior can vary inside tables or when editing a cell.

Suppose you want to format a block of data from B2 to F40. Click B2, then use Ctrl+Shift+Right and Ctrl+Shift+Down only if the data is continuous in those directions. If blank rows or columns break the block, selecting the range with the mouse or entering B2:F40 in the Name Box is more controlled. Keyboard speed is useful, but a deliberate range selection is safer than assuming Excel inferred the intended boundary.

Shortcuts for data entry and formulas

Several shortcuts reduce repetitive typing and make worksheet data easier to manage. They do not replace checking that the selected cells contain the values you intend to change.

Ctrl+D: fill down, copying the top cell of a selected range into the cells below it. Formulas adjust references as they are filled, just as they do when copied normally.
Ctrl+R: fill right, copying the leftmost cell across the selected range.
Alt+Enter: insert a line break within the cell being edited, rather than finishing the entry.
Ctrl+;: enter the current date as a fixed value in the active cell.
Ctrl+Shift+;: enter the current time as a fixed value.
Ctrl+Shift+L: turn filters on or off for a data range. If Excel cannot identify the range or headers as expected, select the relevant data first.
Ctrl+T: create an Excel table from a selected data range and open the Create Table dialog.

The date and time commands insert values, not continuously updating clocks. A date entered with Ctrl+; stays as the date recorded at entry; it does not change tomorrow. For a live date that updates when a workbook recalculates, a worksheet formula is a different tool and should be chosen intentionally. Similarly, filling a formula down with Ctrl+D may change relative cell references. Review the first few results before filling a long column.

Format cells and inspect formulas

Formatting shortcuts help present a worksheet without leaving the keyboard. Ctrl+1 opens the Format Cells dialog, where you can set number formats, alignment, fonts, borders, and protection options. For common number formats, Ctrl+Shift+! applies a number format with two decimal places, and Ctrl+Shift+$ applies a currency format. The displayed currency symbol and some format details can depend on regional settings.

To show or hide worksheet formulas instead of their calculated results, press Ctrl+` (the grave accent key, usually near the upper-left of a US keyboard). This is helpful when checking formulas across a sheet. On some keyboard layouts the accent key is placed differently, so the combination may require locating the corresponding key. Press it again to return to calculated-value display.

When a formula has a cell reference, F4 while editing the reference cycles through relative and absolute forms, such as A1, $A$1, A$1, and $A1. This is useful when copying formulas: an absolute reference stays fixed while a relative reference adjusts. Function keys may require holding Fn on some laptops, depending on the keyboard’s function-key setting.

Windows, Mac, and Excel for the web

On a Mac, common editing commands usually use Command rather than Windows Ctrl: for example, Command+C copies, Command+V pastes, Command+Z undoes, and Command+S saves. This is a useful starting rule, not a guarantee that every Windows shortcut has a direct Command-key equivalent. Some Excel actions use Control, Option, or function keys on Mac, and function keys may require Fn. Check Excel’s Help or the menus on your Mac for the exact command when a combination differs.

Excel for the web runs in a browser, so browser shortcuts can overlap with spreadsheet commands. Many familiar editing shortcuts work, but some commands, function keys, and ribbon access keys differ from desktop Excel. If a key combination switches browser tabs or opens a browser feature, use the Excel ribbon or its search box instead. The web version also has a different interface and may not offer every desktop command in the same way.

On Windows desktop Excel, pressing Alt displays KeyTips: small letter or number labels that guide you through ribbon commands. Press the displayed keys in sequence rather than holding them all together. This is a useful alternative when you know the menu location but not a dedicated shortcut. Ribbon KeyTips can change as the interface changes, so follow the labels shown on screen rather than memorizing an old sequence from another Excel version.

Choose shortcuts and avoid common problems

You do not need to memorize every available command. Start with the actions you repeat most, then add shortcuts when a real task calls for them. A small, dependable set is more useful than a long list remembered imperfectly.

Learn the basics first: copy, paste, undo, save, find, and edit the active cell.
Add navigation and selection commands when you work with large ranges or multiple worksheets.
Use formatting and data shortcuts only after confirming the selected cells and the effect of the command.
Keep a short reference near your workspace and practise on a copy of a workbook if a command could alter important data.

A frequent misconception is that every shortcut behaves identically in every context. For instance, Ctrl+A can select a data region rather than the entire worksheet, and Ctrl+Arrow can stop differently when blanks divide a list. Another common issue is confusing a fixed date or time entry with a formula that updates automatically. If a shortcut produces an unexpected result, press Ctrl+Z promptly if appropriate, then inspect the selection, editing state, keyboard layout, and Excel version before trying again.

Frequently Asked Questions

What is the most useful Excel shortcut to learn first?
Ctrl+Z is a strong first choice because it can undo many recent actions. For everyday work, also learn Ctrl+C, Ctrl+V, and Ctrl+S. Undo is not a substitute for saving important files, and not every action can be undone.

How do I select an entire column or row in Excel?
Click a cell in the target column and press Ctrl+Space to select the column. Press Shift+Space to select the row containing the active cell. Check the highlighted area before deleting, formatting, or replacing content.

How can I move quickly to the last row of data?
Click a cell in the relevant column and press Ctrl+Down to move to the edge of its current data region. A blank cell or gap may affect where Excel stops. Ctrl+End instead moves to Excel’s last used cell, which is not always the last row containing meaningful data.

What is the Excel shortcut for inserting today’s date?
On Windows, press Ctrl+; to enter today’s date as a fixed value. Press Ctrl+Shift+; to enter the current time. These entries do not automatically update later.

Do Excel shortcuts work the same on Mac?
No. Many common editing shortcuts use Command on Mac instead of Windows Ctrl, but other commands differ and some function keys require Fn. Check Excel’s Mac Help or menus for a command-specific equivalent.

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.