Learning how to use keyboard shortcuts in Excel is one of the quickest ways to work faster. Reaching for the mouse breaks your flow, and a handful of key combinations can replace dozens of clicks every day. This guide lists 35 of the most useful Windows shortcuts in tidy tables, explains how the Mac versions differ, and shows how to learn them without trying to memorise everything at once.

How Excel shortcuts work
A plus sign between keys means you hold the first key and tap the next, for example Ctrl+Shift+L. A comma, as in Alt+H, H, means you press the keys one after another. Pressing Alt on its own shows small letter badges called key tips over the ribbon, and Microsoft’s shortcut list uses this system, for example Alt+H, H to choose a fill colour and Alt+H, A, C to centre the contents of a cell.
Everyday essentials
| Task | Windows shortcut |
|---|---|
| Copy | Ctrl+C |
| Cut | Ctrl+X |
| Paste | Ctrl+V |
| Open the Paste Special dialogue box | Ctrl+Alt+V |
| Undo | Ctrl+Z |
| Redo | Ctrl+Y |
| Save | Ctrl+S |
| Select everything | Ctrl+A |
| Find | Ctrl+F |
| Find and replace | Ctrl+H |
| Bold | Ctrl+B |
| Insert a hyperlink | Ctrl+K |
Moving around and selecting
Navigation shortcuts matter most in big spreadsheets, where scrolling with the mouse wastes time. The Ctrl+Arrow combinations jump to the edge of a block of data, and adding Shift extends your selection as you go.
| Task | Windows shortcut |
|---|---|
| Jump to the edge of the current block of data | Ctrl+Arrow key |
| Extend the selection to the edge of the data | Ctrl+Shift+Arrow key |
| Go to cell A1 | Ctrl+Home |
| Go to the last used cell | Ctrl+End |
| Select the whole column | Ctrl+Space |
| Select the whole row | Shift+Space |
| Move to the next worksheet | Ctrl+Page Down |
| Move to the previous worksheet | Ctrl+Page Up |
| Edit the active cell | F2 |
Formulas and data
| Task | Windows shortcut |
|---|---|
| AutoSum the selected cells | Alt+= |
| Switch between absolute and relative references while editing a formula | F4 |
| Create a table | Ctrl+T |
| Turn filters on or off | Ctrl+Shift+L |
| Open the filter drop-down for a column | Alt+Down arrow |
| Fill down from the cell above | Ctrl+D |
| Fill to the right from the cell on the left | Ctrl+R |
| Fill the whole selection with what you typed | Ctrl+Enter |
F4 is worth learning early. Click inside a cell reference while editing a formula and press F4 to cycle through fixed and flexible versions, such as A1, $A$1, A$1 and $A1, instead of typing the dollar signs by hand.

Formatting, dates and charts
| Task | Windows shortcut |
|---|---|
| Open the Format Cells dialogue box | Ctrl+1 |
| Apply currency format | Ctrl+Shift+$ |
| Apply percentage format | Ctrl+Shift+% |
| Enter today’s date | Ctrl+; |
| Create a chart on a new sheet | F11 |
| Insert a new worksheet | Shift+F11 |
Excel shortcuts on a Mac
On a Mac, most Ctrl shortcuts use the Cmd key instead, so copy, paste and undo become Cmd+C, Cmd+V and Cmd+Z. Some common ones change more, according to published Excel shortcut lists:
| Task | Windows | Mac |
|---|---|---|
| Copy | Ctrl+C | Cmd+C |
| Undo | Ctrl+Z | Cmd+Z |
| Switch between absolute and relative references | F4 | Cmd+T |
| AutoSum | Alt+= | Cmd+Shift+T |
Two more Mac points: function keys such as F2 or F4 often need the Fn key held down unless you have changed your keyboard settings, and Excel for Mac does not offer the Alt key-tip system for the ribbon.
How to learn shortcuts without overwhelming yourself
- Pick five a week. Choose the actions you repeat most, such as copy, paste, filter and AutoSum, and force yourself to use the keys for a week.
- Use key tips for the rest. Press Alt, read the letters on the ribbon and follow them. You will pick up the full sequences naturally.
- Keep a cheat sheet nearby. Microsoft publishes a full list called Keyboard shortcuts in Excel on its support site, and the tables above work as a one-page reminder.
- Add favourites to the Quick Access Toolbar. You can then trigger them with Alt plus the button’s position number.
If your shortcuts stop working
The usual causes are a laptop with Fn lock switched on, a keyboard language setting that moves symbols such as $ and %, a stuck modifier key, or Excel being in edit mode, where some shortcuts behave differently. Press Esc, tap each modifier key once and try again. If you use Excel in a web browser, browser shortcuts can take priority over Excel’s.
More in Tech
Shortcuts pair well with other time-savers. Our guides to removing duplicates in Excel and what a macro in Excel is cover tidying data and automating repeat tasks, and if you manage money in spreadsheets, see how to build a cash flow forecast.
Frequently asked questions
What are the most useful Excel shortcuts for beginners?
Start with Ctrl+C, Ctrl+V, Ctrl+Z and Ctrl+S, then add Ctrl+Arrow to move around data, Ctrl+Shift+L for filters and Alt+= for AutoSum.
How do I see every Excel shortcut?
Press Alt to see key tips on the ribbon, and read Microsoft’s Keyboard shortcuts in Excel page on its support site for the full list.
How do I select an entire column or row?
Press Ctrl+Space to select the column of the active cell and Shift+Space to select its row. Combine them to select everything with Ctrl+A.
What does F4 do in Excel?
While you are editing a formula, F4 switches a cell reference between relative and absolute forms. Outside editing, it commonly repeats your last action.
Do the same shortcuts work in Excel for the web?
Many common ones do, but browser shortcuts can take priority, so a few combinations behave differently from the desktop app.




