Excel guide

Excel Keyboard Shortcuts: 30 You Need (Windows and Mac)

Last updated: October 11, 2026 · 4 min read

Clicking through menus takes time. With a few keyboard shortcuts you select, copy, filter and fix a list in seconds. You do not need to learn all 30. Pick the ones you use most and add more later. A dash in the Mac column means: use the menu. Start with Fix 1.

Fix 1

Skip the shortcuts and clean the whole list with the free tools

A shortcut saves seconds. A tool cleans the whole sheet in one run. Try Clean Whitespace, Fix Text Case or Find and Remove Duplicates. They run on your own computer, and your original file stays as it is.

Fix 2

Excel shortcuts to select and move around your list

What you wantWindowsMac
Select the whole listCtrl+ACmd+A
Select a columnCtrl+SpaceCtrl+Space
Select a rowShift+SpaceShift+Space
Select down to the last filled cellCtrl+Shift+ArrowCmd+Shift+Arrow
Jump to the edge of your dataCtrl+ArrowCmd+Arrow
Jump to the first cell (A1)Ctrl+HomeFn+Ctrl+Left
Jump to the last cellCtrl+EndFn+Ctrl+Right
Open the Go To boxF5Ctrl+G
Fix 3

Excel shortcuts to copy, paste and undo

What you wantWindowsMac
CopyCtrl+CCmd+C
CutCtrl+XCmd+X
PasteCtrl+VCmd+V
Paste Special (for example values only)Ctrl+Alt+VCtrl+Cmd+V
UndoCtrl+ZCmd+Z
RedoCtrl+YCmd+Y (or Cmd+Shift+Z)
Repeat the last actionF4Cmd+Y
Fill down from the cell aboveCtrl+DCtrl+D
SaveCtrl+SCmd+S

More Excel shortcuts for editing, rows and columns

What you wantWindowsMac
Edit the cellF2Ctrl+U (or F2)
New line inside a cellAlt+EnterCtrl+Option+Return
Insert today's dateCtrl+;Ctrl+;
Insert rows or columnsCtrl+Shift+PlusCmd+Shift+Plus
Delete rows or columnsCtrl+MinusCmd+Minus
Hide rowsCtrl+9Ctrl+9
Hide columnsCtrl+0Ctrl+0

To insert or delete a whole row or column, select it first with Shift+Space or Ctrl+Space.

Shortcuts to find, replace, filter and format

What you wantWindowsMac
FindCtrl+FCmd+F
Find and ReplaceCtrl+HCtrl+H
Turn the filter on or offCtrl+Shift+LCmd+Shift+F
Flash Fill (Excel copies your pattern)Ctrl+ECtrl+E
Format cellsCtrl+1Cmd+1
Turn a list into a tableCtrl+TCtrl+T

Flash Fill example: type the first name from a full name in the next column. Start the second one and press Ctrl+E. Excel fills the rest. See also our guide on clearing filters.

Excel shortcuts: before and after

JobWith the mouseWith a shortcut
Select a columnClick the letterCtrl+Space
Open ReplaceHome, Find and Select, ReplaceCtrl+H
Turn the filter onData, FilterCtrl+Shift+L

Small steps, but they add up over a big list. Shortcuts can differ a little by Excel version and keyboard.

Clean the whole sheet in one run

These free tools run on your own computer. Your file is never uploaded.

Questions about Excel shortcuts

Do these shortcuts work on a Mac?

Most do, with the Cmd key instead of Ctrl. The Mac column shows the keys. A dash means use the menu.

What does Ctrl+E do in Excel?

It starts Flash Fill. You type an example and Excel fills the rest of the column in the same pattern.

How do I undo a mistake?

Press Ctrl+Z (Cmd+Z on a Mac). Press it again to go back more steps.

How do I find and replace in Excel?

Press Ctrl+H, type what to find and what to put instead, then click Replace All.

Which shortcuts should I learn first?

Start with Ctrl+Z, Ctrl+C, Ctrl+V, Ctrl+A and Ctrl+Shift+L. Add more when these feel easy.

More Excel guides

← All Excel guides