Excel Shortcut Keys for Faster Work on Windows and Mac

Excel shortcut keys let you perform common tasks with the keyboard instead of navigating menus. In Excel for Microsoft 365 on Windows, useful starting points include Ctrl+C and Ctrl+V to copy and paste, Ctrl+Z to undo, Ctrl+S to save, Ctrl+1 to open Format Cells, and Alt+= to insert an AutoSum formula; Mac equivalents for many everyday commands use Command instead of Ctrl.

What Excel shortcuts do and why they help

A keyboard shortcut is a key or combination of keys that runs a command, moves the selection, or changes how you enter data. Shortcuts can speed up repetitive work, but they are also useful for precise actions: selecting a whole row, moving to the edge of a data block, or adding a line break inside a cell. They do not change what a workbook contains unless the command itself edits or formats it.

Excel shortcuts are context-sensitive. Ctrl+C copies selected cells, for example, while Ctrl+1 opens formatting options for the current selection. Some shortcuts act on a cell, some on a selected range, and others on a worksheet or workbook. The same key can also behave differently depending on whether you are editing text inside a cell, working in a dialog box, or using a laptop keyboard with function keys.

The shortcuts below refer to Excel for Microsoft 365 on Windows. Excel for Mac shares many commands but commonly uses Command where Windows uses Ctrl. Excel for the web runs in a browser, where some combinations may be intercepted by the browser or operating system; check the app’s shortcut list if a command behaves differently.

Everyday editing and workbook shortcuts

These commands cover the routine work of entering, correcting, and managing data. Learn the few you use most often first rather than trying to memorize a long list all at once.

Ctrl+C / Ctrl+V / Ctrl+X: Copy, paste, or cut the selected cells or content. On Mac, use Command+C, Command+V, and Command+X.
Ctrl+Z / Ctrl+Y: Undo the previous action or redo an action that was undone. On Mac, the common equivalents are Command+Z and Command+Y.
Ctrl+S: Save the workbook. On Mac, use Command+S. Saving frequently is especially useful before a substantial edit or when working with a local file.
Ctrl+F / Ctrl+H: Find content or open Find and Replace. On Mac, use Command+F and Command+Shift+H for Find and Replace in current Excel versions; menu labels and exact combinations can vary with the release.
F2: Edit the active cell’s contents. Press Enter to accept the edit or Esc to cancel it. On some laptops you may need Fn+F2, depending on the keyboard’s function-key setting.
Alt+Enter: Insert a line break within a cell while editing its contents. This is different from pressing Enter, which usually confirms the entry and moves the selection.
Ctrl+P: Open the Print view. On Mac, use Command+P. Review the preview and print settings before sending a worksheet to a printer.

Moving around a worksheet and selecting cells

Navigation shortcuts are most helpful on large sheets, where repeated scrolling can make it difficult to keep track of a data block. The direction keys and selection rules depend on whether nearby cells contain data.

Ctrl+Arrow key: Move to the edge of the current data region in the arrow’s direction. A blank cell or a gap in the data affects where Excel stops, so this does not always mean the last used cell on the worksheet.
Ctrl+Shift+Arrow key: Extend the selection toward the edge of the data region. Check the highlighted range before applying a formatting change or deletion.
Ctrl+Home: Move to the beginning of the worksheet, normally cell A1. Ctrl+End moves to the last cell Excel considers used, which can be farther than the visible data if formatting or old entries remain in the sheet.
Ctrl+Space: Select the column containing the active cell. Shift+Space selects its row.
Ctrl+Page Up / Ctrl+Page Down: Move to the previous or next worksheet tab in the workbook. This is handy when a file has many tabs.
Tab and Enter: Move the selection through cells as you enter data. Tab generally moves right and Enter generally moves down, though Excel’s Enter behavior can be changed in its options.

On Mac, common navigation shortcuts differ more than basic copy-and-paste commands. For instance, Mac keyboards and Excel releases may use different combinations for moving between sheets, and some laptops require the Fn key for function-key commands. If a Windows shortcut is not recognized, use Excel’s Help or keyboard-shortcut reference for the installed Mac version rather than assuming every Ctrl combination translates directly.

Entering data, filling cells, and adding dates

When you need to repeat an entry across a selection or populate a sequence, a shortcut can save many individual edits. Select the relevant cells first, then use a command whose effect matches the selection.

Ctrl+Enter: Enter the same value or formula into all cells in the selected range. Type the entry, then press Ctrl+Enter instead of Enter. Confirm that the intended range is selected before using it.
Ctrl+D: Fill down from the top cell of the selected range. Ctrl+R fills right from the leftmost cell. These commands copy the contents and, where applicable, relative references adjust as they are filled.
Ctrl+;: Insert the current date as a fixed value in the active cell. Ctrl+Shift+;: Insert the current time as a fixed value. These entries do not update automatically as the date or time changes.
Alt+Down Arrow: Open a drop-down list for a cell when a suitable list or filter control is available. The result depends on the cell’s context, such as a data-validation list or a filtered table header.

A fixed date inserted with Ctrl+; is not the same as a formula that recalculates to show the current date. This distinction matters for records: a fixed entry can preserve the date an event was logged, while a recalculating date is better suited to a display that should always reflect the current day. Pick the method that matches the meaning of the data.

Formatting, tables, and filters

Formatting shortcuts are useful when a worksheet needs consistent presentation. Excel applies many formatting commands to the active cell or selected range, so select the intended cells before using them.

Ctrl+1: Open the Format Cells dialog, where you can set number formats, alignment, fonts, borders, and other cell properties. On Mac, Command+1 commonly opens the corresponding formatting dialog.
Ctrl+B / Ctrl+I / Ctrl+U: Toggle bold, italic, or underline formatting. The Mac equivalents commonly use Command with the same letter.
Ctrl+Shift+%: Apply percentage formatting. Check the displayed value: formatting changes how a number is shown, and does not by itself convert the underlying value into a different quantity.
Ctrl+T: Create an Excel table from a selected data range. Review the range in the Create Table dialog and indicate whether the first row contains headers.
Ctrl+Shift+L: Turn AutoFilter buttons on or off for a data range. In a table, filter controls are normally part of the table already; the shortcut’s effect depends on the current selection and worksheet state.

A frequent misunderstanding is that a shortcut such as Ctrl+B changes the data itself. It changes the cell’s formatting, while the underlying value remains the same. Similarly, Ctrl+T creates a structured table, not merely a colored block: tables provide header filters and expand as new adjacent data is added. If you only want a visual style, use the formatting options rather than converting the range.

Formulas and quick calculations

Shortcuts can help start or edit calculations, but they do not remove the need to inspect the result. Alt+= inserts AutoSum, which proposes a range of nearby numbers and creates a SUM calculation. Excel displays the proposed range before you confirm it, so check that it includes the intended cells and excludes headings or unrelated values.

F4 has two particularly useful behaviors. While editing a formula reference, it cycles through relative and absolute reference styles, such as A1, $A$1, A$1, and $A1. When you are not editing a reference, F4 can repeat the last action where Excel supports repeating it. Because the result depends on context, look at the formula bar or cell before accepting an edit.

For example, if AutoSum proposes a total over only part of a column, you can adjust the proposed range before pressing Enter. If you copy a formula to another cell, references without dollar signs usually adjust to their new position; dollar signs hold a row, column, or both fixed. Understanding this behavior is more reliable than treating a shortcut as a substitute for checking formulas.

Windows and Mac shortcut differences

Many familiar commands have a straightforward key substitution on Mac: Command often takes the place of Ctrl for copy, paste, save, find, undo, and common text formatting. This is a useful starting rule, not a guarantee that every Windows shortcut has an identical Mac version. Excel for Mac has its own shortcut mappings, and macOS may reserve some keys for system functions.

Function keys are a common source of confusion. On a compact laptop, F2 or another function key may control brightness or media playback unless you press Fn as well or change the keyboard’s function-key setting. External keyboards can behave differently. If a shortcut seems not to work, test whether the command is available through the ribbon or menu, and check the keyboard layout and system settings.

Excel for the web adds another consideration: the browser may use a key combination for its own command. The web app supports many Excel shortcuts, but not every desktop command works the same way. For an important workflow, verify the shortcut in the version where the workbook will actually be edited.

How to learn shortcuts without making mistakes

Start with actions you repeat daily, then add shortcuts that solve a specific inconvenience. A short, practical set is easier to remember than a long chart that is rarely used. Keep the difference between moving, selecting, editing, and formatting in mind: a selection shortcut can affect hundreds of cells at once.

Choose a small group of commands, such as copy, paste, undo, save, and find.
Practice them in a disposable or copied workbook so that accidental edits are easy to recover.
Before using a shortcut that changes a range, check the active cell and highlighted selection.
Use the ribbon or a menu when you are unsure what a shortcut will do; the visible command name helps confirm your intention.
Look up version-specific shortcuts in Excel Help if you use Mac, Excel for the web, a non-English keyboard layout, or a customized keyboard.

Undo is useful, but it is not a replacement for a backup. Some actions cannot be undone, and actions performed outside the workbook may not appear in Excel’s undo history. Save a copy before large-scale edits, particularly when working with imported data or a complex model.

Frequently Asked Questions

What are the most useful Excel shortcut keys for beginners?
Start with Ctrl+C, Ctrl+V, Ctrl+Z, Ctrl+S, Ctrl+F, and Ctrl+1 on Windows. They cover copying, pasting, undoing, saving, finding, and formatting. On Mac, the common equivalents use Command for most of these commands.

What is the shortcut for AutoSum in Excel?
In Excel for Microsoft 365 on Windows, press Alt+= to insert AutoSum. Inspect the suggested range before confirming it, since Excel may not select exactly the cells you intended.

How do I edit a cell without replacing its contents?
Select the cell and press F2 to edit its existing contents. On a laptop, you may need Fn+F2. Press Enter to accept your edit or Esc to cancel it.

What is the shortcut to insert today’s date in Excel?
Press Ctrl+; on Windows to enter today’s date as a fixed value. It will not change tomorrow. The Mac shortcut can depend on the Excel version and keyboard, so check Excel for Mac’s shortcut reference if that combination does not work.

Why does Ctrl+End go past my visible data?
Ctrl+End moves to the last cell Excel considers used, not necessarily the last cell containing visible text or numbers. Old entries or formatting can extend the used area. Inspect the region and remove unnecessary content or formatting carefully if you want to reduce it.

Do Excel shortcuts work the same way on Mac and Windows?
No. Many everyday commands are similar, often with Command replacing Ctrl on Mac, but navigation and function-key shortcuts can differ. Excel for the web may also be affected by browser shortcuts, so confirm less familiar combinations in the version you use.

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.