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.

Blog

Guides to getting more out of Excel, every function explained, and what each error means.

Guides Errors Functions

Guides

Errors explained

#N/A #N/A means a lookup could not find what it was asked to find. The formula is usually fine; the value is not in the list. #REF! #REF! means the formula points at a cell or position that does not exist: off the edge of a range, or a cell that has been deleted. #VALUE! #VALUE! means a formula was given the wrong kind of thing: most often text where a number was needed. #DIV/0! #DIV/0! means a formula tried to divide by zero or by an empty cell, which has no answer. #NAME? #NAME? means Excel found a word in the formula it does not recognise: usually a misspelt function or text without quotes. #NUM! #NUM! means a calculation has no valid numeric answer: the square root of a negative number, or a result too large to hold. #SPILL! #SPILL! means a formula wants to fill several cells with its results, but something is already in the way. #CALC! #CALC! means a formula that returns a list has ended up with nothing to return, or was written in a way Excel cannot work out.

Functions explained

Maths

ABS The size of a number without its sign AVERAGE The mean of a set of numbers COUNT How many cells hold numbers COUNTA How many cells are not empty INT Rounds down to a whole number MAX The largest number MIN The smallest number MOD The remainder after dividing POWER A number raised to a power ROUND Rounds to a number of decimal places ROUNDDOWN Rounds towards zero ROUNDUP Rounds away from zero SQRT Square root SUM Adds numbers together SUMPRODUCT Multiplies ranges together, then adds the results

Logic

AND True if every test is true IF One result if a test is true, another if not IFERROR A fallback when a formula gives an error IFS The value for the first test that is true NOT Turns true into false and false into true OR True if any test is true SWITCH Picks a result by matching a value

Conditional maths

AVERAGEIF Averages the cells that meet a condition COUNTIF Counts the cells that meet a condition COUNTIFS Counts rows that meet several conditions SUMIF Adds the cells that meet a condition SUMIFS Adds the cells that meet several conditions

Lookup

CHOOSE Picks a value from a list by number INDEX The value at a position in a range INDIRECT The range named by a piece of text MATCH The position of a value in a range OFFSET A range a set distance from a starting cell VLOOKUP Finds a value in the first column and returns one from the same row XLOOKUP Finds a value in one range and returns the match from another XMATCH The position of a value in a range

Text

FIND Where one piece of text sits inside another (case-sensitive) LEFT Characters from the start of text LEN How many characters text has LOWER Text in lower case MID Characters from the middle of text PROPER Capitalises each word RIGHT Characters from the end of text SEARCH Where one piece of text sits inside another SUBSTITUTE Replaces one piece of text with another TEXT A number shown as text in a given format TEXTBEFORE The text before a separator TEXTJOIN Joins text with a separator TEXTSPLIT Splits text into cells at a separator TRIM Removes extra spaces UPPER Text in capitals

Dates

DATE A date from its parts DATEDIF The time between two dates EOMONTH The last day of a month, some months away MONTH The month of a date NETWORKDAYS Working days between two dates TODAY Today's date WEEKDAY The day of the week as a number YEAR The year of a date

Statistics

LARGE The k-th largest value MEDIAN The middle value RANK Where a number ranks in a list STDEV.S Standard deviation of a sample

Dynamic arrays

BYROW Applies a calculation to each row CHOOSECOLS Chosen columns of a range FILTER The rows that pass a test LAMBDA A reusable calculation of your own LET Names a value so a formula can reuse it MAP Applies a calculation to each value REDUCE Folds a range down to one value SEQUENCE A run of numbers SORT A range in sorted order SORTBY A range sorted by another range TAKE The first or last rows of a range UNIQUE Each distinct value once VSTACK Ranges stacked one above another

Finance

FV What a series of payments grows to IPMT The interest part of a loan payment IRR The return rate of a series of cash flows NPER How many payments a loan takes NPV Present value of future cash flows PMT The payment on a loan PV What a series of payments is worth today RATE The interest rate of a loan XIRR The return rate of cash flows on given dates XNPV Present value of cash flows on given dates

Not affiliated with Microsoft. Excel is a trademark of Microsoft Corporation.