Tips

Essential Excel Keyboard Shortcuts That Save Hours

Excel keyboard shortcuts for moving, selecting, editing, formatting and formulas, plus a simple way to make them stick.

By ExcelPanda Team · Published · 4 min read

Reaching for the mouse costs a second or two each time, and across a day of spreadsheet work that adds up. These shortcuts are the ones people use most, grouped by what you are doing.

Move and select

Move and select shortcuts

ShortcutWhat it does
Ctrl + Arrow keyJump to the edge of the data
Ctrl + Shift + Arrow keySelect from here to the edge of the data
Ctrl + HomeGo to cell A1
Ctrl + EndGo to the last used cell
Ctrl + SpaceSelect the whole column
Shift + SpaceSelect the whole row

Edit and fill

Edit and fill shortcuts

ShortcutWhat it does
F2Edit the active cell
Ctrl + Z / Ctrl + YUndo / redo
Ctrl + DFill down from the cell above
Ctrl + RFill right from the cell on the left
Alt + EnterStart a new line inside a cell
Ctrl + ;Enter today’s date

Format and structure

Format and structure shortcuts

ShortcutWhat it does
Ctrl + 1Open Format Cells
Ctrl + TTurn a range into a Table
Ctrl + Shift + LTurn filters on or off
Ctrl + +Insert cells, rows or columns
Ctrl + -Delete cells, rows or columns

Formula shortcuts

Formula shortcuts

ShortcutWhat it does
Alt + =AutoSum the cells next to the active one
F4Cycle a reference between relative and absolute ($A$1)
Ctrl + `Show formulas instead of values
Ctrl + EFlash Fill: fill a column from a pattern you typed

Flash Fill is in Excel 2013 and later. F4 saves the most mistakes, because it stops formulas breaking when you copy them.

How to actually learn them

  1. Pick five shortcuts and write them on a sticky note.
  2. Use only the keyboard for those actions for a week, even when it feels slower.
  3. Add five more the next week.

Shortcuts are one part of working faster. For the full picture, see our 30-day Excel plan.

Frequently asked questions

What are the most useful Excel shortcuts?

Ctrl+Arrow keys to jump through data, Ctrl+Shift+Arrow to select it, F4 to lock references, Alt+= to sum and Ctrl+T to make a Table cover most daily work.

Do these shortcuts work on a Mac?

Many work with Cmd in place of Ctrl, but some differ. Check the shortcut list for Excel on Mac if one does not respond.

How many shortcuts should I learn?

Start with five and use them until they are automatic, then add more. A few well-learned shortcuts beat a long list you forget.

Is there a shortcut to show all formulas?

Yes. Press Ctrl+` (the key above Tab) to switch between showing values and showing formulas.

Sources and disclaimers

Shortcuts are for Excel on Windows and can differ on Mac or in Excel for the web. ExcelPanda is not affiliated with or endorsed by Microsoft. Microsoft and Excel are trademarks of the Microsoft group of companies.