Excel Keyboard Shortcuts to Know for Faster Work

The most useful Excel keyboard shortcuts are Ctrl+C, Ctrl+V and Ctrl+Z for copying, pasting and undoing; Ctrl+Arrow keys for moving through data; Ctrl+1 for cell formatting; and Alt+= for AutoSum. These are Windows shortcuts for Excel for Microsoft 365; on Mac, many Ctrl shortcuts use Command instead, while some commands have different keys.

How Excel shortcuts work

A shortcut combines keys to perform an action without choosing it from the ribbon or a menu. In Windows Excel, Ctrl is common for workbook commands, Shift often extends a selection, and Alt can expose ribbon key tips. On a Mac, Command commonly replaces Ctrl for actions such as copy and save, but not every shortcut follows that pattern. The exact keys can also depend on your keyboard and Excel version.

Press the keys shown together: Ctrl+C means hold Ctrl and press C. A plus sign in a shortcut description means the keys are pressed at the same time. A comma means a sequence: press one key combination, release it, then press the next. The Alt key tips shown on the ribbon are sequences, not simultaneous combinations.

Shortcuts act on the current selection. Before using one that changes or deletes content, check which cell or range is selected. You can undo many editing actions with Ctrl+Z, but it cannot reverse every operation—for example, running a macro cannot be undone that way.

Move around a worksheet efficiently

Navigation shortcuts are especially useful in large sheets, where repeated scrolling can make it easy to lose your place. These Windows shortcuts work in a worksheet:

Arrow keys: Move one cell in the direction of the arrow.
Ctrl+Arrow key: Jump to the edge of the current data region in that direction. If the next cell is blank, Excel moves to the next occupied cell or the edge of the worksheet, depending on the surrounding data.
Ctrl+Home: Go to the beginning of the worksheet, usually cell A1.
Ctrl+End: Go to the last cell Excel considers used. This can be beyond the visible data if previously used cells retain formatting.
Home: Move to the first column of the current row.
Ctrl+Page Up and Ctrl+Page Down: Switch to the previous or next worksheet tab.

On Mac, Command+Arrow moves to the edge of a data region, and Command+Home and Command+End provide worksheet navigation. The behavior of Home, End and function keys can depend on the Mac keyboard; a laptop may require Fn with a key. If a shortcut moves somewhere unexpected, check whether the active cell is inside a continuous block of data or beside blank cells.

Select cells, rows and columns

To select a range while navigating, hold Shift as you move. For instance, click a cell, then press Shift+Arrow to extend the selection by one cell. In Windows, Ctrl+Shift+Arrow extends the selection to the edge of the data region, while Shift+Space selects the current row and Ctrl+Space selects the current column. These are handy for selecting a whole row or column before applying formatting or inserting cells.

On Mac, Command+Shift+Arrow extends a selection to the edge of a data region. Shift+Space selects a row, and Control+Space selects a column in Excel, though macOS may use Control+Space for an input-source feature. If that system shortcut interferes, change the macOS keyboard setting or select the column using Excel’s row and column headings instead.

To select a contiguous block, start in a cell within it and use Ctrl+Shift+Arrow in the direction you need. This is faster than dragging, but it follows the structure of the data: blank cells can stop the selection. For scattered cells, hold Ctrl on Windows while clicking additional cells. On Mac, use Command while selecting additional cells.

Edit and manage cell content

These commands cover frequent editing tasks. On Mac, Command generally replaces Ctrl for the standard clipboard and undo commands.

Ctrl+C, Ctrl+X and Ctrl+V: Copy, cut and paste. On Mac, use Command+C, Command+X and Command+V.
Ctrl+Z and Ctrl+Y: Undo and redo. On Mac, use Command+Z to undo; redo is commonly Command+Y, though the available redo command can depend on the action and Excel version.
F2: Edit the active cell’s contents. On Mac, Control+U is the usual shortcut to edit the active cell.
Ctrl+D: Fill the selected cell or range with the content from the top cell. Ctrl+R fills from the leftmost cell across the selected range.
Ctrl+F and Ctrl+H: Open Find and Replace. On Mac, Command+F opens Find; the Replace command is available from Excel’s Find interface or menus.
Ctrl+S: Save the workbook. On Mac, use Command+S.

For example, if A2 contains a formula and A3:A10 is selected with A3 as the top cell, Ctrl+D fills the formula down through the selected range, adjusting relative references as Excel copies it. Check the selected range first: Fill Down replaces the contents of the lower cells with copies from the top.

Format cells and enter common values

Formatting shortcuts help apply a change without opening several ribbon menus. In Windows Excel, Ctrl+1 opens the Format Cells dialog, where you can change number formats, alignment, font, borders and fill. On Mac, Command+1 opens Format Cells.

Ctrl+B, Ctrl+I and Ctrl+U: Toggle bold, italic and underline. On Mac, use Command+B, Command+I and Command+U.
Ctrl+Shift+1: Apply a number format with two decimal places. Ctrl+Shift+4 applies a currency format, and Ctrl+Shift+5 applies a percentage format.
Ctrl+;: Insert the current date as a fixed value. It does not update automatically on a later day.
Ctrl+Shift+;: Insert the current time as a fixed value.
Ctrl+K: Open the dialog for inserting a hyperlink.

Number-format shortcuts change how a value appears, not the underlying value. If a cell contains 0.25, applying the percentage format displays 25%; it does not turn the cell into a different calculation. If the displayed result seems wrong, check the number format before changing the formula or data.

Work faster with formulas and data

Excel has shortcuts for entering formulas and handling common data tasks. In Windows, Alt+= inserts an AutoSum formula for a nearby range Excel identifies. Review the proposed range before accepting it: if the table contains a blank row or unrelated numbers nearby, the suggested cells may not be the ones you intend to total.

When entering a formula, F4 can cycle a cell reference through relative and absolute forms. For example, while editing a formula containing A1, place the cursor at that reference and press F4 to cycle through forms such as A1, $A$1, A$1 and $A1. The dollar signs lock the column, row or both when a formula is copied. On some Mac keyboards, you may need Fn+F4, and the exact behavior can vary with keyboard settings.

Ctrl+T creates an Excel table from a selected data range and opens the Create Table dialog. Tables make it easier to filter and format structured data, and their ranges can expand as you add rows. Confirm the range and whether the first row contains headers before accepting. In Excel for Mac, Control+T is commonly used for Create Table.

Ctrl+Shift+L toggles filters for a range with headers in Windows Excel. Filters hide rows that do not match your criteria; they do not delete those rows. When a filter is active, inspect the column’s filter icon if records appear to be missing. In Excel for Microsoft 365 on Windows, Ctrl+E can invoke Flash Fill, which detects a pattern in adjacent data and fills values accordingly. Review its results, especially when names or text have exceptions, because Flash Fill produces values rather than a live formula.

Shortcuts for choosing the right action

Some shortcuts are easy to confuse because they sound similar but affect different things. Copy duplicates a selection; cut marks it to be moved. Undo reverses a recent supported action, while deleting a cell’s contents is a change that may be undone but can still affect formulas that refer to it. Fill Down and Fill Right copy the contents of a selected source cell into other cells; they are not the same as copying a range to the clipboard.

Use the shortcut that matches the job:

For quick movement across a dense list, use Ctrl+Arrow; for a precise one-cell move, use an arrow key.
To select data to the edge of a block, add Shift to Ctrl+Arrow; to select a full row or column, use Shift+Space or Ctrl+Space.
To change how numbers appear, use a number-format shortcut or Ctrl+1; do not edit a valid value just to make its display look different.
To total an adjacent range, try Alt+=, then verify the range in the inserted formula.

Shortcuts are most reliable when the sheet has a clear structure, with headers and uninterrupted data ranges. If a command has an unexpected effect, press Esc to cancel a current selection or dialog when possible, and use Ctrl+Z for a supported change you have already made.

Windows, Mac and Excel for the web

Windows is the reference platform for the Ctrl-based shortcuts in this guide. On Mac, many everyday actions use Command instead: copy, paste, save and bold are familiar examples. But this is a useful rule of thumb, not a universal conversion. Navigation, editing, function-key behavior and ribbon commands can differ, and macOS itself may reserve some key combinations.

Excel for the web also runs inside a browser, so a shortcut may be handled by the browser instead of Excel or may behave differently from the desktop app. If a combination does not work, check Excel’s Help for keyboard shortcuts and consider whether the browser has claimed the same keys. Function keys may also require a modifier depending on the computer’s keyboard settings.

You can discover many Windows ribbon shortcuts by pressing Alt: Excel displays key tips over ribbon tabs and commands. Press the displayed letters in sequence to reach the command, or press Esc to leave key-tip mode. This is useful when you know a command’s location but do not remember its shortcut. The letters can vary with the ribbon layout and language, so follow the on-screen tips rather than memorizing a sequence from another installation.

Common shortcut problems

If a shortcut does not work, first check whether a cell is being edited. While the insertion cursor is inside a cell or the formula bar, keys may edit text instead of triggering worksheet navigation. Press Enter or Esc to finish or cancel editing, then try again. Also confirm that Excel, rather than another open window, has focus.

A second common issue is that Ctrl+End lands far beyond the visible table. Excel can retain a used range because cells were previously edited or formatted. This does not necessarily mean there is hidden data, but it can affect navigation and file size. Check the intervening rows and columns before deleting anything, especially in a shared workbook.

Finally, shortcut behavior can depend on selected objects and keyboard layout. A chart, dialog box, worksheet cell and formula bar do not all respond to the same keys. If a shortcut is unfamiliar or potentially destructive, use the ribbon command first or consult Excel’s in-product shortcut help. That helps confirm the command for your platform and avoids assuming every Windows shortcut has a direct Mac equivalent.

Frequently Asked Questions

What is the shortcut for undo in Excel?
In Windows, press Ctrl+Z. On Mac, press Command+Z. Undo applies to many ordinary editing actions, but not every action is reversible; macros, for example, cannot be undone with Ctrl+Z.

How do I jump to the last row or column of data?
Click a cell in the data region and press Ctrl+an arrow key in Windows, or Command+an arrow key on Mac, to move to the edge of that region. Blank cells can divide a region, so the destination depends on the layout.

What shortcut opens Format Cells?
Press Ctrl+1 in Windows Excel or Command+1 on Mac. The dialog lets you adjust number format, alignment, font, borders and fill.

How can I insert today’s date in a cell?
In Windows, press Ctrl+; to enter the current date as a fixed value. It will not recalculate tomorrow. A formula such as =TODAY() instead returns a date that updates when Excel recalculates.

Why does Ctrl+End go past my data?
Excel’s used range can include cells that were previously edited or formatted, even if they now look empty. Review the area before removing content or formatting, since cells outside the visible table may still be intentional.

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.