Excel keyboard shortcuts let you perform common tasks instantly instead of hunting through menus. The most useful include Ctrl+C and Ctrl+V to copy and paste, Ctrl+Z to undo, Ctrl+Arrow to jump across data, and Alt+= to AutoSum. Learning even ten of them can save you several hours a week.
Below are 30 of the highest-value Excel shortcuts, grouped by what they do, so you can learn them a few at a time. They are written for Excel on Windows; there is a Mac note near the end. Pick five you would use today, and the rest will follow.
Free download: grab our one-page Windows & Mac Excel shortcuts cheat sheet (PDF), print it, and pin it by your desk.
Why are Excel keyboard shortcuts worth learning?
Every time you reach for the mouse to click through a menu, you lose a few seconds. Do that hundreds of times a day and it adds up to real time, and a real break in concentration. Shortcuts keep your hands on the keyboard and your attention on the work. You do not need all 30 at once: learning the handful you use most often is where the biggest time savings come from.
What are the essential everyday Excel shortcuts?
These are the ones worth knowing first, because you use them constantly:
- Ctrl + C – copy
- Ctrl + X – cut
- Ctrl + V – paste
- Ctrl + Z – undo
- Ctrl + Y – redo
- Ctrl + S – save
- Ctrl + F – find
- Ctrl + A – select all
- Ctrl + P – print
Which shortcuts help you navigate and select data fast?
Moving around a big spreadsheet with the mouse is slow. These jump you around instantly:
- Ctrl + Arrow key – jump to the edge of your data in that direction
- Ctrl + Shift + Arrow key – select everything from the current cell to the edge of the data
- Ctrl + Home – go back to cell A1
- Ctrl + Spacebar – select the entire column
- Shift + Spacebar – select the entire row
What are the best shortcuts for rows, columns and cells?
Editing structure is far faster from the keyboard:
- Ctrl + Shift + Plus (+) – insert rows or columns
- Ctrl + Minus (-) – delete rows or columns
- F2 – edit the active cell (jump straight into it)
- Ctrl + D – fill down (copy the cell above into the selection)
- Ctrl + R – fill right (copy the cell to the left)
- Ctrl + ; (semicolon) – insert today’s date
Which shortcuts speed up formatting?
Formatting is where a lot of clicking hides. These cut it right down:
- Ctrl + B – bold
- Ctrl + 1 – open the Format Cells dialog (the most useful formatting shortcut of all)
- Ctrl + 5 – apply strikethrough
- Alt + H, H – open the fill colour menu
- Alt + H, M, C – merge and centre
- Ctrl + Shift + % (percent) – apply percentage format
What are the must-know formula and data shortcuts?
A few shortcuts pay for themselves the moment you work with formulas or lists:
- Alt + = (equals) – AutoSum the selected range
- F4 – toggle a formula reference between relative and absolute ($A$1); also repeats your last action
- Ctrl + Shift + L – turn filters on or off
- Alt + Down arrow – open the filter dropdown on the selected column
That is 30. If you only remember a few, make them Ctrl + 1, Ctrl + Arrow, Alt + =, Ctrl + D and F4; they cover the most common time sinks.
Are Excel keyboard shortcuts different on a Mac?
Mostly, you swap Ctrl for Command (Cmd). So copy is Cmd+C, save is Cmd+S, and so on. A few differ: Format Cells is Cmd+1, and some Alt-based Windows shortcuts use Control or Option on a Mac. The Ribbon key sequences (the Alt+H style shortcuts) are the main ones that do not translate directly, so on a Mac it is worth learning the equivalents from Excel’s menus.
What’s the fastest way to learn Excel shortcuts?
Do not try to memorise all 30 at once. Pick the five you would use most, put them on a sticky note, and force yourself to use them for a week; they become automatic quickly. Our free Windows & Mac Excel shortcuts cheat sheet helps (print it and keep it by your keyboard), and hands-on practice with a trainer is faster still.
For the fundamentals these shortcuts sit on top of, see our Complete Guide to Microsoft Excel. To build real speed and confidence, our Excel Beginner course covers navigation, formatting and shortcuts hands-on with a Microsoft Certified Trainer, and you can browse every level on our Microsoft Excel training courses page. Once you are quick with the basics, our guides to Excel Pivot Tables and XLOOKUP are the natural next steps.
Frequently asked questions
The most useful everyday shortcuts are Ctrl+C (copy), Ctrl+V (paste), Ctrl+Z (undo), Ctrl+S (save), Ctrl+Arrow to jump across data, Ctrl+1 to open Format Cells, and Alt+= to AutoSum. Learning even ten shortcuts noticeably speeds up your work.
Select the cell below the column of numbers and press Alt+= (Alt and the equals key). This inserts an AutoSum formula for the range above. Press Enter to confirm it.
Select the cell or text and press Ctrl+5. Pressing Ctrl+5 again removes the strikethrough. On a Mac, use Cmd+Shift+X.
Select a row (Shift+Spacebar selects the current row), then press Ctrl+Shift+Plus (+) to insert a new row above it. The same shortcut inserts a column when a column is selected.
Mostly. On a Mac you generally replace Ctrl with Command (Cmd), so Cmd+C, Cmd+S and so on. A few shortcuts differ, and the Alt-based Ribbon sequences do not translate directly, so it is worth checking the Mac equivalents.
Learn a few at a time rather than all at once. Pick the five you would use most, keep a cheat sheet nearby, and use them deliberately for a week until they become automatic. Structured training accelerates this a lot.
