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.

ABCDEFGHIJKLMN
1
Region
Rep
Sales
Region
Total
2
North
Ali
1200
North
1950
3
South
Bea
800
4
North
Cal
450
5
East
Dee
990
6
South
Eli
610
7
North
Fay
300
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

More to try

Each of these works on the sheet. Press one to put it in F2.

  • gives 1410

    The condition can be typed straight into the formula, in quotes.

  • gives 3600

    With two arguments, the same range is tested and added. Number tests go in quotes.

  • gives 2400

    The sign <> means 'not equal to': everything except North.

Common mistakes

  • Ranges of different sizes. The tested range and the range to add should cover exactly the same rows.
  • Forgetting the quotes round a number test: write ">500", not >500.
  • Needing two conditions. SUMIF takes one; use SUMIFS for more.

Practise it

Total sales for one region →

Related functions