Excel Shortcut Keys: Most Useful Keyboard Shortcuts

Important MS Excel keyboard shortcuts for formatting, navigation, selection, formulas and data. Work faster in Excel.

Learning a few Excel shortcuts saves hours of work. These are the ones used most often in offices. Ctrl means the Control key.

On this page (4 sections)
  1. Basic editing
  2. Formatting
  3. Navigation and selection
  4. Formulas and data

Basic editing

ShortcutWhat it does
Ctrl+CCopy
Ctrl+XCut
Ctrl+VPaste
Ctrl+ZUndo
Ctrl+YRedo
Ctrl+SSave
F12Save As
Ctrl+PPrint
Ctrl+FFind
Ctrl+HFind and replace
F2Edit the active cell
Alt+EnterStart a new line inside a cell

Formatting

ShortcutWhat it does
Ctrl+BBold
Ctrl+IItalic
Ctrl+UUnderline
Ctrl+1Open Format Cells
Ctrl+Shift+%Percent format
Ctrl+Shift+$Currency format
Ctrl+Shift+LTurn filters on or off
Ctrl+TCreate a table

Navigation and selection

ShortcutWhat it does
Ctrl+Arrow keysJump to the edge of data
Ctrl+HomeGo to cell A1
Ctrl+EndGo to the last used cell
Ctrl+ASelect all
Ctrl+SpaceSelect the whole column
Shift+SpaceSelect the whole row
Ctrl+Page DownNext worksheet
Ctrl+Page UpPrevious worksheet
Ctrl+G or F5Go To a cell

Formulas and data

ShortcutWhat it does
Alt+=AutoSum
F4Switch between relative and absolute references
Ctrl+;Insert today's date
Ctrl+Shift+;Insert the current time
Ctrl+DFill down
Ctrl+RFill right
Ctrl+9Hide the selected rows
Ctrl+0Hide the selected columns

Frequently asked questions

Which shortcut inserts today's date in Excel?

Press Ctrl+; (semicolon).

How do I turn filters on quickly?

Select any cell in your data and press Ctrl+Shift+L.

What does F4 do in Excel?

While editing a formula, F4 switches a cell reference between relative and absolute forms. Outside editing it repeats the last action.

Test yourself

All MS Excel tests

Learn it in a course

More quick guides

WhatsApp us