Excel Keyboard Shortcuts That Save Time Every Day

Last updated: November 2026 · Windows shortcuts for Excel for Microsoft 365, Excel 2021, Excel 2019 and Excel 2016. On a Mac, use Cmd for most Ctrl shortcuts.

Reaching for the mouse dozens of times an hour adds up. People who work quickly in Excel are rarely faster typists; they simply know a handful of shortcuts that move them around the sheet, select data and apply formatting without hunting through the ribbon. You do not need to learn hundreds. Start with one group below, use those shortcuts for a week until they become automatic, then add the next group.

Moving around the sheet

ShortcutWhat it does
Ctrl + Arrow keyJump to the edge of the current block of data. The single most useful navigation shortcut.
Ctrl + HomeGo to cell A1 (or the top-left unfrozen cell).
Ctrl + EndGo to the last used cell on the sheet.
Ctrl + Page Down / Page UpMove to the next or previous worksheet.
F5 or Ctrl + GGo To a cell address or named range; click Special for blanks, formulas, errors and more.
Ctrl + BackspaceScroll back to show the active cell after you have scrolled away.

Selecting cells

ShortcutWhat it does
Shift + Arrow keyExtend the selection one cell at a time.
Ctrl + Shift + Arrow keyExtend the selection to the edge of the data. Select a whole column of figures in one move.
Ctrl + ASelect the current data region; press again to select the whole sheet.
Shift + SpaceSelect the entire row.
Ctrl + SpaceSelect the entire column.
Ctrl + clickAdd separate cells or ranges to the selection.

Entering and editing data

ShortcutWhat it does
F2Edit the active cell with the cursor at the end.
Ctrl + EnterEnter the same value or formula into every selected cell at once.
Alt + EnterStart a new line inside the same cell.
Ctrl + D / Ctrl + RFill down from the cell above / fill right from the cell to the left.
Ctrl + ;Insert today's date as a fixed value.
Ctrl + Shift + ;Insert the current time.
Ctrl + EFlash Fill: complete a pattern from an example.
Ctrl + Alt + VPaste Special, for pasting values, formats or transposing.
Ctrl + Z / Ctrl + YUndo / redo or repeat the last action.

A favourite trick combines two of these: select a range, press F5, choose Special > Blanks, type = and press the Up arrow, then press Ctrl + Enter. Every blank cell is filled with the value above it, which is perfect for completing a report exported with gaps under each group heading.

Formatting

ShortcutWhat it does
Ctrl + 1Open Format Cells, where every number, alignment, border and fill option lives.
Ctrl + B / I / UBold, italic, underline.
Ctrl + Shift + 1Number format with thousands separator and two decimals.
Ctrl + Shift + 5Percentage format.
Ctrl + Shift + 3Date format.
Ctrl + Shift + &Add an outline border.
Alt, H, O, IAuto-fit the selected columns.

For more on making sheets readable, see Use of Formatting.

Working with formulas

ShortcutWhat it does
Alt + =AutoSum the cells above or to the left.
F4While editing a reference, cycle through $A$1, A$1, $A1 and A1. See absolute and relative references.
Shift + F3Open the Insert Function dialog with help for each argument.
Ctrl + ` (grave accent, left of 1)Show all formulas instead of results; press again to switch back.
F9Recalculate, or evaluate a selected part of a formula while editing.
Ctrl + [Jump to the cells a formula refers to.

Rows, columns and sheets

ShortcutWhat it does
Ctrl + +Insert cells, rows or columns (select whole rows first to insert rows).
Ctrl + -Delete the selected cells, rows or columns.
Ctrl + 9 / Ctrl + 0Hide selected rows / columns.
Shift + F11Insert a new worksheet.
Alt + Shift + Right ArrowGroup selected rows or columns into an outline.

Working with data

ShortcutWhat it does
Ctrl + TConvert a range into an Excel Table.
Ctrl + Shift + LTurn filters on or off.
Alt + Down ArrowOpen a filter or drop-down list in the active cell.
Ctrl + F / Ctrl + HFind / Find and Replace.
Alt + F1Create a chart from the selected data on the same sheet.
Alt, N, V, TInsert a pivot table.

The Alt key: a shortcut for every command

Press and release Alt and small letters appear on every ribbon tab and button. Press the letters in turn to run any command without the mouse. For example, Alt, A, M opens Remove Duplicates and Alt, W, F, F freezes panes. You do not need to memorise these; follow the letters on screen and after a few repetitions your fingers remember them.

You can also add your most-used commands to the Quick Access Toolbar. They then get the shortcuts Alt + 1, Alt + 2 and so on, in the order they appear.

How to make shortcuts stick

Back to: all Excel tutorials.