Common Excel Shortcut Keys and How to Use Them

The most useful Excel shortcut keys on Windows include Ctrl+C and Ctrl+V to copy and paste, Ctrl+Z to undo, Ctrl+S to save, Ctrl+Arrow keys to move through data, Ctrl+1 to format cells, and Alt+= to insert AutoSum. On a Mac, many everyday shortcuts use Command instead of Ctrl, but some Excel commands have different keys.

Why Excel shortcuts are useful

A keyboard shortcut runs a command without requiring you to find it on the ribbon or in a menu. That can make frequent tasks—editing values, moving around a worksheet, applying formats, or checking formulas—faster and easier to repeat. Shortcuts are especially helpful in large workbooks, where reaching a distant row or column with the mouse can take time.

Excel shortcuts are commands, not a separate mode. You can usually use them while a worksheet is active, but a shortcut may behave differently if you are typing inside a cell, editing a formula, or working in a dialog box. If a command does not work as expected, first check where the focus is: press Esc to leave cell editing, or click the worksheet before trying again.

The examples below are for Excel for Microsoft 365 on Windows. Mac keyboards use Command, Option, and Control in different combinations, and laptops may require the Fn key to access function keys. Excel for the web also runs inside a browser, so browser commands or keyboard settings can affect some shortcuts.

Everyday editing and file shortcuts

These are useful starting points because they work across many common spreadsheet tasks:

Ctrl+C, Ctrl+X, and Ctrl+V: Copy, cut, and paste the selected cells or content. On Mac, use Command+C, Command+X, and Command+V.
Ctrl+Z and Ctrl+Y: Undo and redo many actions. On Mac, Command+Z undoes; Command+Y commonly redoes in Excel.
Ctrl+S: Save the workbook. On Mac, use Command+S. For a workbook stored in OneDrive or SharePoint with AutoSave enabled, changes may save automatically, but Ctrl+S remains a useful habit.
Ctrl+P: Open the print screen. On Mac, use Command+P.
Ctrl+F: Find text or values. Ctrl+H opens Find and Replace. On Mac, use Command+F to find; the shortcut for replacing can depend on the Excel version and keyboard setup.
Ctrl+B, Ctrl+I, and Ctrl+U: Toggle bold, italic, and underline for selected cells or text. On Mac, the corresponding shortcuts generally use Command.

Copying a cell copies more than its displayed value by default: it can include the formula, formatting, and other cell content. If you need only the result, use Paste Special and choose Values rather than assuming Ctrl+V will paste plain text. You can open Paste Special from the Home tab or use the Windows key sequence Ctrl+Alt+V, then choose the appropriate option in the dialog.

Moving around a worksheet

Navigation shortcuts help you move through a sheet without scrolling manually. Their behavior depends on the layout of the data, so it is worth trying them in a copy of a workbook or an unimportant area first.

Arrow keys: Move one cell in the indicated direction.
Ctrl+Arrow key: Move to the edge of the current data region, or to the next occupied cell or worksheet boundary if the path contains a blank. For example, from a filled cell in a continuous column of values, Ctrl+Down moves to the bottom of that block.
Home: Move to the beginning of the row. Ctrl+Home moves to the start of the worksheet, normally cell A1.
Ctrl+End: Move to the last cell Excel considers used. This can be beyond the visible data if cells farther down or to the right were previously formatted or edited.
Page Up and Page Down: Move one screen up or down. Add Alt to move one screen left or right in many Windows Excel layouts.
Ctrl+Page Up and Ctrl+Page Down: Move to the previous or next worksheet tab. On Mac, Control+Page Up and Control+Page Down are commonly used, though laptop function-key settings may require Fn.

For example, if a sales list occupies cells A1:D250 without blank rows in the first column, clicking a cell in that list and pressing Ctrl+Down can take you to the bottom of the contiguous block. If the column has a blank row, Excel stops at the edge of the section instead. Ctrl+End is not always a reliable way to find the last meaningful record, because formatting in otherwise empty cells can enlarge Excel’s used range.

Selecting cells, rows, and columns

Selection shortcuts pair naturally with navigation keys. Pressing Shift while moving extends a selection; adding Ctrl can extend it to the edge of a data region.

Shift+Arrow key: Extend the current selection by one cell.
Ctrl+Shift+Arrow key: Extend the selection to the edge of the current data region in that direction.
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; pressing it again can select more of the worksheet, depending on the active cell and context.

On Mac, Command+A is commonly used to select data, while Control+Space and Shift+Space can select a column and row. macOS may reserve Control+Space for changing input sources, so that shortcut can be intercepted by the operating system; change the system assignment or use Excel’s menu if needed. Selecting a full row or column before inserting is a convenient way to add one in the correct position, but check the selection before deleting because a whole-row or whole-column selection affects far more cells than a single-cell selection.

Entering and filling data

Once the active cell is in the right place, these shortcuts help enter or repeat information:

F2: Edit the active cell. If the cell contains a formula, this lets you inspect or change it. On some laptops, press Fn+F2.
Enter: Commit an entry and move to another cell, usually the cell below. The direction can be changed in Excel’s editing options.
Alt+Enter: Start a new line within the same cell while entering or editing text.
Ctrl+Enter: Enter the same value or formula into every cell in a selected range. Type the entry, then press Ctrl+Enter.
Ctrl+D: Fill down from the top cell of a selected range. Ctrl+R fills right from the leftmost cell.
Ctrl+;: Insert the current date as a fixed value. Ctrl+Shift+;: Insert the current time as a fixed value.

Filling a formula down copies the formula with relative references adjusted for each row. If the first cell contains a formula referring to the cell immediately to its left, the next row’s copied formula will typically refer to the next row’s left-hand cell. This differs from a live date function: the Ctrl+; shortcut inserts today’s date as a value, so it does not update tomorrow. On Mac, date and time shortcuts can differ with the Excel release and keyboard layout; use Excel’s Help search for the command if the Windows combination does not work.

Formatting and number shortcuts

Formatting shortcuts are useful when a value is correct but difficult to read. Ctrl+1 opens the Format Cells dialog on Windows, where you can choose number formats, alignment, fonts, borders, and protection options. On Mac, Command+1 commonly opens the corresponding dialog.

Ctrl+Shift+$: Apply a currency format.
Ctrl+Shift+%: Apply a percentage format.
Ctrl+Shift+!: Apply a number format with two decimal places and a thousands separator.
Ctrl+Shift+#: Apply a date format in many Windows Excel configurations.
Ctrl+Shift+L: Turn filters on or off for a data range. Excel may first identify the relevant range around the active cell.

Number formats change how a value appears, not necessarily the value stored in the cell. For example, applying a percentage format to 0.25 displays 25%; it does not turn the underlying number into a different quantity. By contrast, typing 25% enters a value equivalent to 0.25. If a shortcut produces a different format on your keyboard, use Ctrl+1 and select the format directly; keyboard layouts and regional settings can affect punctuation-based combinations.

Formula and data-analysis shortcuts

Excel has shortcuts that help create and inspect formulas without replacing the need to understand what a formula refers to:

Alt+=: Insert AutoSum. Excel proposes a range of adjacent numbers; review the highlighted range before pressing Enter.
F4 while editing a formula reference: Cycle through relative, absolute, and mixed references. For example, a reference can change from A1 to $A$1, then to A$1 and $A1. On Mac, Command+T commonly cycles reference types; function-key behavior may also require Fn.
Ctrl+`: Show or hide formulas in the worksheet instead of their calculated results. The grave accent key is often near the upper-left corner of a US keyboard.
Alt+Down Arrow: Open a filter list or a data-validation list when the active cell supports that command.
Ctrl+T: Create an Excel table from a selected data range and open the table creation dialog.

AutoSum is a suggestion, not a guarantee that Excel has chosen the intended cells. If there is a blank row inside a list or another number nearby, check the proposed range and adjust it before accepting. Tables created with Ctrl+T add useful structure, including filter buttons and automatic expansion in many situations; confirm that the header option is set correctly if the first row contains column names.

Windows, Mac, and web differences

Many familiar shortcuts follow a broad pattern: Windows Ctrl often corresponds to Mac Command for commands such as copy, paste, save, find, and bold. That pattern is not universal. Excel uses Control or Option for some Mac actions, and function keys may be assigned to brightness, volume, or other system controls. If F2 or F4 does not respond, try holding Fn or review the keyboard settings for standard function keys.

Excel for the web supports many familiar shortcuts, but it runs in a browser. A browser or operating system can claim a key combination before Excel receives it, and some commands may open a browser feature rather than an Excel command. If a shortcut behaves unexpectedly, check Excel’s Help or keyboard-shortcut list for the web app, and use the ribbon command as a dependable alternative. The Windows combinations in this guide should not be assumed to work identically in every browser or on every keyboard.

Shortcuts can also vary with the language and layout of a keyboard. A key labelled differently may require a different physical combination, especially for symbols such as $, %, or the grave accent. The command itself is more important than memorizing one layout: when a combination is inconvenient, locate the command on the ribbon and learn the displayed shortcut for your setup.

How to learn shortcuts without mistakes

Learning a small set tied to tasks you already perform is more effective than trying to memorize a long chart. Start with saving, undoing, copying, finding, moving between sheets, and formatting cells. Add formula and selection shortcuts once those basic commands feel familiar.

Choose one repeated task. If you regularly inspect long lists, practice Ctrl+Arrow and Ctrl+Shift+Arrow in a safe sample range.
Notice the active cell and selection. Many mistakes come from applying a valid command to the wrong range, not from the shortcut itself.
Use undo as a safety net, not a substitute for checking. Ctrl+Z reverses many recent actions, but some operations and external changes may not be recoverable through undo.
Use the ribbon when unsure. The command name and visible selection make it easier to confirm what Excel is about to do.

For example, to format a column of decimal values as percentages, select the intended cells, press Ctrl+Shift+%, and check that values such as 0.4 display as 40%. If the cells instead contain the number 40, the result may display as 4000%; undo the format and confirm what the underlying values represent before continuing.

Frequently Asked Questions

What is the most useful shortcut in Excel?
There is no single best shortcut for everyone, but Ctrl+Z is a useful safety command, Ctrl+S saves, and Ctrl+Arrow keys make large worksheets easier to navigate. Start with the commands that match your regular work.

What is the Excel shortcut for AutoSum?
On Windows, press Alt+= in or near the range you want to total. Check Excel’s suggested range before pressing Enter, especially if there are blank cells or nearby numbers.

How do I switch between sheets in Excel?
On Windows, press Ctrl+Page Up for the previous sheet and Ctrl+Page Down for the next one. Mac and laptop keyboards may require Control plus the page key and, in some cases, Fn.

Why are Excel shortcuts not working on my laptop?
The Fn key, operating-system shortcuts, browser commands, keyboard layout, or cell-editing focus may be affecting the combination. Try Fn with a function key, click the worksheet, or run the command from the ribbon to identify the issue.

Do Excel shortcuts work the same on Mac?
No. Many common commands use Command instead of Windows Ctrl, but not all shortcuts follow that rule. Function keys and macOS keyboard assignments can also change behavior, so check Excel Help for a Mac-specific command when a combination differs.

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.