Excel Shortcuts: The Keyboard Keys Worth Learning First

I keep a client list, an orders tracker and a content calendar in Excel, and the day I stopped reaching for the mouse every few seconds was the day spreadsheets stopped feeling like a chore. You don't need hundreds of shortcuts. You need about twenty, and you'll pick them up within a week if you use them on your own files. These are the Windows shortcuts from Microsoft's own list; on a Mac most use Cmd instead of Ctrl.

The everyday Excel shortcuts I'd learn first

What you want to do	Press
Save the workbook	Ctrl+S
Undo your last action	Ctrl+Z
Copy, cut and paste	Ctrl+C, Ctrl+X, Ctrl+V
Bold the selected cells	Ctrl+B
Open the Format Cells box	Ctrl+1
Turn a range into a table	Ctrl+T or Ctrl+L
Copy the top cell down a selection	Ctrl+D
Check spelling	F7
Edit the active cell	F2
Close the workbook	Ctrl+W

If you only learn three today, make them Ctrl+Z, Ctrl+T and Ctrl+1. Undo saves your nerves, a table gives you filters and banded rows in one keystroke, and Format Cells is where you fix dates and number styles.

Moving around a big order list without scrolling

Paging through a long list of orders is slow and you lose your place. These navigation shortcuts get you there instantly:

1. Ctrl+Arrow key jumps to the edge of the current block of data. Press Ctrl+Down in column A and you land on the last order.
2. Ctrl+Home takes you back to the top left of the sheet.
3. Ctrl+End goes to the last used cell on the sheet, which is handy for spotting stray data far below your list.
4. Ctrl+Page down and Ctrl+Page up move to the next or previous sheet in the workbook.
5. Ctrl+Spacebar selects the whole column and Shift+Spacebar selects the whole row.

Hold Shift with any of those and Excel selects as it moves. Ctrl+Shift+Down from the top of a column selects every filled cell below it, which beats dragging the mouse down a few screens.

Date, time and data entry keys

These are the ones I use most on a stock sheet or delivery log:

• Ctrl+; types today's date into the cell.
• Ctrl+Shift+: types the current time.
• Alt+Enter starts a new line inside the same cell, so an address can sit on several lines.
• Ctrl+Enter fills every selected cell with what you've just typed. Select 10 cells, type Pending, press Ctrl+Enter, done.
• Ctrl+Shift+Plus opens the Insert dialog and Ctrl+Minus opens the Delete dialog.

Using Alt to reach every ribbon command

This is the shortcut most people miss. Press Alt and let go. Excel puts a small letter on each ribbon tab: H for Home, N for Insert, P for Page Layout, M for Formulas, A for Data, R for Review and W for View. Press the letter, and a fresh set of letters appears on every button in that tab.

So instead of memorising hundreds of combinations, you read them off the screen. Alt, then H, then B gives you the borders menu. Alt, then Q puts you in the search box, where you can type the name of any command you can't find. Microsoft also says most of the old Alt menu shortcuts from earlier versions still work if you know the full sequence.

Hiding rows and switching to formula view

Two quieter shortcuts are worth knowing. Ctrl+9 hides the selected rows and Ctrl+0 hides the selected columns, which is useful before you share a sheet on screen. And Ctrl+` (the key above Tab on most keyboards) flips the whole sheet between showing results and showing the formulas behind them. When a total looks wrong, that's my first move. If your sums involve splitting quantities, my guide to dividing numbers in Excel and fixing the #DIV/0! error covers the most common mistake.

Where shortcut lists trip people up

Microsoft's list is written for Excel on Windows with a full keyboard. On a laptop without a separate number pad, some keys sit behind an Fn key, so F2 might need Fn+F2. On a Mac, most Ctrl shortcuts use Cmd, and Microsoft keeps a separate Mac list. And if a shortcut does nothing, check you're not in the middle of editing a cell: most shortcuts only work once you've pressed Enter or Esc to leave the cell.

It's also worth knowing that a few combinations behave differently depending on context. Ctrl+A selects the current block of data first, then the whole sheet if you press it again. That's helpful once you know it and baffling if you don't.

How to make the shortcuts stick

Pick five a week and use only those until they're automatic. Print the table above, stick it next to your screen, and force yourself to use the keyboard even when the mouse feels quicker. It won't feel quicker for a few days. After that it will. Once you're moving round big sheets by keyboard, freezing panes in Excel keeps your header row in view while you jump about.

My short answer

You don't need to be a spreadsheet wizard. Learn Ctrl+Z, Ctrl+T, Ctrl+1, Ctrl+Arrow and Ctrl+; this week, then press Alt whenever you're hunting for a button. I'd say that handful saves me more time than any template I've bought into, and it's free.

Frequently asked questions

What is the most useful Excel shortcut?

For most people it's Ctrl+Z to undo, followed by Ctrl+Arrow to jump to the edge of your data and Ctrl+T to create a table.

How do I see all the shortcuts on the ribbon?

Press and release Alt. Excel shows a letter on each tab, then a letter on each button once you pick a tab.

What is the shortcut for today's date in Excel?

Press Ctrl and the semicolon key. Ctrl+Shift+colon enters the current time.

Why isn't my Excel shortcut working?

You might still be editing a cell, so press Enter or Esc first. On some laptops the function keys need the Fn key too.

Do Excel shortcuts work on a Mac?

Many do, but most swap Ctrl for Cmd. Microsoft publishes a separate list for Excel on Mac.