
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
| Shortcut | What it does |
|---|---|
| Ctrl + Arrow key | Jump to the edge of the data |
| Ctrl + Shift + Arrow key | Select from here to the edge of the data |
| Ctrl + Home | Go to cell A1 |
| Ctrl + End | Go to the last used cell |
| Ctrl + Space | Select the whole column |
| Shift + Space | Select the whole row |
Edit and fill
Edit and fill shortcuts
| Shortcut | What it does |
|---|---|
| F2 | Edit the active cell |
| Ctrl + Z / Ctrl + Y | Undo / redo |
| Ctrl + D | Fill down from the cell above |
| Ctrl + R | Fill right from the cell on the left |
| Alt + Enter | Start a new line inside a cell |
| Ctrl + ; | Enter today’s date |
Format and structure
Format and structure shortcuts
| Shortcut | What it does |
|---|---|
| Ctrl + 1 | Open Format Cells |
| Ctrl + T | Turn a range into a Table |
| Ctrl + Shift + L | Turn filters on or off |
| Ctrl + + | Insert cells, rows or columns |
| Ctrl + - | Delete cells, rows or columns |
Formula shortcuts
Formula shortcuts
| Shortcut | What it does |
|---|---|
| Alt + = | AutoSum the cells next to the active one |
| F4 | Cycle a reference between relative and absolute ($A$1) |
| Ctrl + ` | Show formulas instead of values |
| Ctrl + E | Flash 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
- Pick five shortcuts and write them on a sticky note.
- Use only the keyboard for those actions for a week, even when it feels slower.
- 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.
.png)