Keyboard

No mouse needed.

Anywhere

←↑↓→
Move the selection around the page
Enter
Open whatever is selected
1…9
Go to a section along the top (or, in a workbook, to one of its sheets)
CtrlQ
Leave an open workbook for its list. Works while in the sheet; asks first if you have typed anything
Alt→
Next section (Alt ← for previous), or next sheet in a workbook. Also Alt PgDn and Alt PgUp
CtrlPgDn
Next section or sheet, as in Excel. Needs focus mode
CtrlHome
Top of the page (Ctrl End for the bottom)
S
Start, or continue after your last solved challenge
X
A random function drill (on the Drills page)
G
Jump into the spreadsheet
F
Focus mode: full screen, browser shortcuts handed to the page
?F1
Show or hide this list

On a challenge

CtrlEnter
Check your answer; once it is right, go to the next challenge. In an exam, the next question. Works while in the sheet
Ctrl/
Show a hint. Works while in the sheet
C
Check your answer
H
Show a hint
AltR
Reset the sheet. Works while in the sheet
AltP
Previous question in an exam (Alt N for the next). Works while in the sheet
B
Begin a practice exam

Moving and selecting in a spreadsheet

←↑↓→
Move one cell
Ctrl↓
Jump to the edge of the data
Home
Start of the row (Ctrl Home for A1, Ctrl End for the last cell)
CtrlG
Go to a cell or range: type it in the name box. Also F5
AltPgDn
Next sheet of a workbook with several (Alt PgUp for previous). Its sheets take over the tabs along the bottom. Mid-formula, select cells there to use them
Shift↓
Select a range (add Ctrl to reach the edge of the data)
ShiftSpace
Select the row (Ctrl Space for the column)
CtrlA
Select everything in use
EnterTab
Move down or right. With a range selected, travel through it
Esc
Cancel a copy, or leave the sheet for the page

Writing a formula

=
Start a formula (or just type)
Tab
Complete the suggested function name
←↑↓→
Pick a cell; hold Shift for a range
F4
Lock the reference: A1, $A$1, A$1, $A1
F2
Edit a cell, or switch the arrows between picking cells and moving the text cursor
Alt=
AutoSum the numbers above
Ctrl'
Copy the formula from the cell above
Enter
Confirm. Esc cancels
CtrlEnter
With a range selected, fill every cell with what you typed

Editing a spreadsheet

CtrlC
Copy (Ctrl X to cut)
CtrlV
Paste. Add Shift to paste values only
CtrlD
Fill down: from the cell above, or the top row through a range
CtrlR
Fill right
Delete
Clear the selected cells
CtrlZ
Undo (Ctrl Y to redo)
Ctrl[
Go to the cells a formula uses (Ctrl ] for cells that use this one)
Ctrl`
Show formulas instead of results

Formatting

CtrlB
Bold (Ctrl I italic, Ctrl U underline, Ctrl 5 strikethrough)
CtrlShift1
Number with two decimals and thousands commas
CtrlShift4
Currency
CtrlShift5
Percentage
CtrlShift3
Date (Ctrl Shift 2 for time, Ctrl Shift 6 for scientific)
CtrlShift~
General: remove the number format
CtrlShift7
Border round the selection (Ctrl Shift − removes borders)

On a Mac, use ⌘ wherever Ctrl is shown and Option wherever Alt is shown (Ctrl Space is taken by macOS). For number formats on a Mac use Control+Shift, as Excel does: ⌘+Shift+3, 4 and 5 are macOS screenshots. Ctrl+PgUp/PgDn, Ctrl+W, Ctrl+T and Ctrl+N belong to the browser; focus mode hands them to the page in Chrome and Edge.

Course · 6 lessons · 38 shortcuts

Learn Excel shortcuts

The shortcuts that make Excel fast, for Windows and Mac, in the order worth learning them. Each one has a live sheet to practise on. It only counts when you do it with the keys: the mouse does not.

Shortcut Learned

Lesson 1Getting around

Jump to the edge of the data Ctrl Not learned yetGo to the start of the row Home Not learned yetGo to cell A1 Ctrl Home Not learned yetGo to the last used cell Ctrl End Not learned yetGo to a cell Ctrl G Not learned yet

Lesson 2Selecting

Extend the selection Shift Not learned yetSelect to the edge of the data Ctrl Shift Not learned yetSelect the whole row Shift Space Not learned yetSelect the whole column Ctrl Space Not learned yetSelect all the data Ctrl A Not learned yet

Lesson 3Entering and editing

Edit a cell F2 Not learned yetClear cells Delete Not learned yetUndo Ctrl Z Not learned yetRedo Ctrl Y Not learned yetFill the selection with one entry Ctrl Enter Not learned yetComplete a function name Tab Not learned yet

Lesson 4Copying and filling

Copy and paste Ctrl C Not learned yetCut and paste Ctrl X Not learned yetPaste values Ctrl Shift V Not learned yetFill down Ctrl D Not learned yetFill right Ctrl R Not learned yetCopy the formula above Ctrl ' Not learned yet

Lesson 5Working with formulas

AutoSum Alt = Not learned yetLock a reference F4 Not learned yetShow formulas Ctrl ` Not learned yetGo to the cells a formula uses Ctrl [ Not learned yetGo to the cells that use this one Ctrl ] Not learned yet

Lesson 6Formatting

Bold Ctrl B Not learned yetItalic Ctrl I Not learned yetUnderline Ctrl U Not learned yetStrikethrough Ctrl 5 Not learned yetNumber format Ctrl Shift 1 Not learned yetDate format Ctrl Shift 3 Not learned yetCurrency format Ctrl Shift 4 Not learned yetPercentage format Ctrl Shift 5 Not learned yetGeneral format Ctrl Shift ~ Not learned yetOutline border Ctrl Shift 7 Not learned yetRemove borders Ctrl Shift − Not learned yet