Home

Excel keyboard shortcuts

Shortcuts are the fastest way to look fluent in Excel. Each one below has its Windows and Mac keys and, where your browser allows it, a drill you can practice in a real grid.

Shortcut speed-run

Ten shortcuts against the clock in a live grid. See how fast you are, then beat it.

Start the speed-run

Select

What it doesWindowsMacPractice
Add another range to the selectionShift+F8Fn+Shift+F8
Extend the selection by one cellShift+RightShift+RightPractice
Select one screen downShift+PageDownFn+Shift+Down
Select the current region or the whole sheetCtrl+ACmd+APractice
Select the whole columnCtrl+SpaceCtrl+SpacePractice
Select the whole rowShift+SpaceShift+SpacePractice
Select to the last cell in useCtrl+Shift+EndFn+Ctrl+Shift+Right
Select to the last filled cellCtrl+Shift+DownCmd+Shift+DownPractice
Select to the start of the rowShift+HomeFn+Shift+Left
Select to the start of the sheetCtrl+Shift+HomeFn+Ctrl+Shift+Left
Turn extend selection mode on or offF8Fn+F8

Edit

What it doesWindowsMacPractice
Add or edit a noteShift+F2Fn+Shift+F2
Cancel the entryEscEscPractice
Check spellingF7Fn+F7
Clear the cell contentsDeleteDelete
CopyCtrl+CCmd+C
Copy the formula from the cell aboveCtrl+'Ctrl+'
CutCtrl+XCmd+X
Delete the selected rows or cellsCtrl+-Cmd+-
Edit the active cellF2Ctrl+UPractice
Enter the same value in every selected cellCtrl+EnterCtrl+ReturnPractice
Fill downCtrl+DCmd+DPractice
Fill rightCtrl+RCmd+RPractice
Insert a chart on the sheetAlt+F1Fn+Option+F1
Insert the current timeCtrl+Shift+:Cmd+;
Insert today's dateCtrl+;Ctrl+;
Open a dropdown listAlt+DownOption+Down
Open the right-click menuShift+F10Fn+Shift+F10
PasteCtrl+VCmd+V
Paste SpecialCtrl+Alt+VCtrl+Cmd+V
RedoCtrl+YCmd+YPractice
Repeat the last actionF4Cmd+Y
Start a new line in a cellAlt+EnterOption+Return
Turn filters on or offCtrl+Shift+LCmd+Shift+F
UndoCtrl+ZCmd+ZPractice

Format

What it doesWindowsMacPractice
Add an outline borderCtrl+Shift+7Cmd+Option+0
Apply strikethroughCtrl+5Cmd+Shift+X
Apply the Currency formatCtrl+Shift+4Ctrl+Shift+4
Apply the Date formatCtrl+Shift+3Ctrl+Shift+3
Apply the Number formatCtrl+Shift+1Ctrl+Shift+1
Apply the Scientific formatCtrl+Shift+6Ctrl+Shift+6
Apply the Time formatCtrl+Shift+2Ctrl+Shift+2
Apply the percent formatCtrl+Shift+5Ctrl+Shift+5
Group rows or columnsAlt+Shift+RightCmd+Shift+K
Hide the selected columnsCtrl+0Ctrl+0
Hide the selected rowsCtrl+9Ctrl+9
Open Format CellsCtrl+1Cmd+1
Underline textCtrl+UCmd+U
Ungroup rows or columnsAlt+Shift+LeftCmd+Shift+J
Unhide rowsCtrl+Shift+9Ctrl+Shift+9

Formulas

Workbook

What it doesWindowsMacPractice
Close ExcelAlt+F4Cmd+Q
Close the workbookCtrl+WCmd+W
Create a chart on a new sheetF11Fn+F11
Create a new workbookCtrl+NCmd+N
Format data as a tableCtrl+TCtrl+T
Insert a new sheetShift+F11Shift+F11
Open a workbookCtrl+OCmd+O
Open the VBA editorAlt+F11Fn+Option+F11
Open the list of macrosAlt+F8Fn+Option+F8
Save as a new fileF12Cmd+Shift+S
Save the workbookCtrl+SCmd+S
Show or hide the ribbonCtrl+F1Cmd+Option+R
Switch to the next open workbookCtrl+TabCtrl+Tab

Good to know

Why shortcuts are worth learning

A mouse is fine for things you do once a day. For the things you do a hundred times, such as jumping to the end of a column, selecting a block of data, filling a formula down or making a reference absolute, the keyboard is several times faster and never makes you hunt for a button. Watch someone who is fast in Excel, and most of the speed comes from a dozen shortcuts, not from rare functions.

Shortcuts matter in tests too. Timed Excel assessments rarely ask about them directly, but if you can jump, select and fill with the keyboard, you have more minutes left for the hard questions.

The shortcuts to learn first

Start with moving around: Ctrl and an arrow key jumps to the edge of your data, and adding Shift selects everything on the way. Then learn the editing keys: F2 to edit a cell without clearing it, Enter and Tab to confirm and move on, Esc to cancel, Ctrl+Z to undo and Ctrl+D to fill down. F4 for absolute references and Alt+= for AutoSum come next. Those ten cover most of a working day.

Once they feel automatic, pick up the format shortcuts, such as Ctrl+Shift+1 for numbers and Ctrl+Shift+5 for percentages, and the ones for switching sheets and saving.

How the drills work

Many shortcut pages have a drill: a small live grid and one task, such as jumping to the last number in a column. You press the real keys on your own keyboard, and the drill checks that the shortcut did the job, not just that you pressed something. Repeat it a few times and it starts to stick. The speed-run puts ten of them against the clock, so you can watch yourself get faster.

Some combinations, such as Ctrl+Tab, Ctrl+W and F11, belong to your browser, and a web page can't catch them. Those pages explain the shortcut and ask you to practice it in Excel itself.

Windows and Mac

Every page shows the Windows keys and the Mac keys side by side. On a Mac, Ctrl usually becomes Cmd, but not always: some Excel shortcuts keep Ctrl, and many need Fn to reach Home, End, Page Up, Page Down or the F keys on a laptop keyboard. If an F key changes the volume or brightness instead, hold Fn, or turn on standard function keys in your keyboard settings.

Other languages and keyboards

In some language versions of Excel, letter shortcuts are translated. In Danish Excel, for example, bold is Ctrl+F instead of Ctrl+B. The F keys, the arrow keys and Ctrl+Shift with a number work the same in every language, so if a colleague abroad uses a different letter for the same command, that is probably why.

Google Sheets

Many of the shortcuts for moving, selecting and formatting are the same in Google Sheets. Sheets runs in a browser, so it uses other keys where the browser has taken the Excel ones: strikethrough, for example, is Alt+Shift+5.

A little every day

Shortcuts are muscle memory, so short and often beats long and rare. Pick two or three new ones a week, use them on purpose in your own work, and run the speed-run now and then to check they have stuck. The ones you stop thinking about are the ones you have learned.