Home / Tech
Tech

How to Use Keyboard Shortcuts in Excel: 35 Essentials

Illustration for How to Use Keyboard Shortcuts in Excel: 35 Essentials

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.

Illustration showing the main idea of How to Use Keyboard Shortcuts in Excel: 35 Essentials

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.

Checklist-style illustration for How to Use Keyboard Shortcuts in Excel: 35 Essentials

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.

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.