Spreadsheet

Keys

On a Mac, Cmd works wherever Ctrl is shown.

Type

Replace the cell; the arrows then move on

Enter, F2, double click

Edit the cell; the arrows move the caret

Enter, Tab

Keep the edit and move down, or right

Escape

Leave the cell as it was

Alt+Enter

A new line inside a cell

Ctrl+Arrow

To the edge of the data

Shift with any move

Extend the selection

Shift+Space, Ctrl+Space, Ctrl+A

Select the row, the column, everything

Ctrl+C, Ctrl+X, Ctrl+V

Copy, cut, paste, to and from other spreadsheets. Cut and paste moves cells, and formulas pointing at them follow

Ctrl+Z, Ctrl+Y

Undo, redo

Ctrl+D, Ctrl+R

Fill down, fill right

Alt+/

Search the menus

Delete

Clear the selection

Ctrl+Alt+=, Ctrl+Alt+-

Insert or delete rows, or columns when whole columns are selected

Ctrl+B, Ctrl+I, Ctrl+U

Bold, italic, underline

Ctrl+Shift+X

Strikethrough

Ctrl+Shift+. and ,

Bigger and smaller text

Double click a column's edge

Fit the column to what is in it

Insert, Chart

Chart the selection; drag a chart to move it, its corner to resize it, Enter or Edit to change it, arrows to read it

Drag a selection's corner

Fill on past it: a series carries on, anything else repeats

Ctrl+Shift+1, 4, 5, ~

Number, currency, percent, general

Ctrl+\

Clear formatting

Ctrl+Shift+L

Turn a filter on or off for the data around the active cell

Alt+Down

On a filter's heading, open its sort and filter panel

Right click

Sort, filter, copy, paste, and insert or delete rows and columns

Formatting changes how a cell looks, not what it holds: a number formatted as currency is still the same number to a formula. Delete clears what was typed and keeps the formatting; Clear formatting does the other.

Sort range sorts by more than one column: the first decides, and each after it only orders the rows the ones above left tied.

A sort orders the rows under a filter's headings, or what is selected and nothing else: a whole column sorts that column alone. With a single cell chosen, it sorts the block of data around it, whole rows together. A first row of text stays in place as headings. Numbers sort by value, even typed as text; Numbers in text also sorts Item 2 before Item 10. A filter hides rows, and copying, clearing, filling and deleting rows then leave the hidden ones alone. Formulas still count them.

On a touch screen, tap a cell to choose it and tap it again to edit it. Hold a finger on a cell, or on a row or column heading, for the menu.

A book holds up to 50 sheets, as tabs along the bottom. Double-click a tab to rename it; right-click it, or use the list button beside +, for its menu. Alt+PgDn and Alt+PgUp go from sheet to sheet, and Shift+F11 adds one. A formula reads another sheet as Sheet2!A1, or 'Sales 2026'!B2:B9 when its name has spaces in; renaming the sheet rewrites them, and deleting it turns them to #REF!.

Dates and times are numbers underneath, as in every spreadsheet: type 2026-10-03, 10/3/2026 (month first), Oct 3, 2026, 14:30 or 2:30 PM and it keeps the look it was typed with. =A1+7 is a week on and shows as a date; one date less another is the days between. Format > Date shows any number as one.

Ctrl+F finds, in what the cells show, or in what was typed with In formulas; Ctrl+Shift+H (or Ctrl+H) replaces, in what was typed, formulas only with In formulas. Replace all is one step for undo.

A formula starts with =, as in =SUM(B2:B9). While typing one, click a cell to put its reference in, drag across cells for a range, or click a column’s heading for all of it; Shift-click stretches what was just pointed at, and clicking again swaps it for another cell. A $ keeps a reference fixed when it is copied. ' at the start keeps a cell as text.

The functions, by kind:

Math ABS, ACOS, ASIN, ATAN, ATAN2, CEILING, COMBIN, COS, COSH, DEGREES, EVEN, EXP, FACT, FLOOR, GCD, INT, LCM, LN, LOG, LOG10, MOD, MROUND, ODD, PERMUT, PI, POWER, PRODUCT, QUOTIENT, RADIANS, RAND, RANDBETWEEN, ROUND, ROUNDDOWN, ROUNDUP, SIGN, SIN, SINH, SQRT, SUM, SUMPRODUCT, SUMSQ, TAN, TANH, TRUNC

Statistics AVEDEV, AVERAGE, COUNT, COUNTA, DEVSQ, GEOMEAN, HARMEAN, KURT, LARGE, MAX, MEDIAN, MIN, MODE, MODE.SNGL, PERCENTILE, PERCENTILE.EXC, PERCENTILE.INC, QUARTILE, QUARTILE.EXC, QUARTILE.INC, RANK, RANK.AVG, RANK.EQ, SKEW, SMALL, STANDARDIZE, STDEV, STDEV.P, STDEV.S, STDEVP, VAR, VAR.P, VAR.S, VARP

With a condition AGGREGATE, AVERAGEIF, AVERAGEIFS, COUNTBLANK, COUNTIF, COUNTIFS, MAXIFS, MINIFS, SUBTOTAL, SUMIF, SUMIFS

Two ranges CORREL, COVAR, COVARIANCE.P, COVARIANCE.S, FORECAST, FORECAST.LINEAR, INTERCEPT, PEARSON, RSQ, SLOPE, STEYX

Distributions and tests BETA.DIST, BETA.INV, BINOM.DIST, CHISQ.DIST, CHISQ.DIST.RT, CHISQ.INV, CHISQ.INV.RT, CHISQ.TEST, CONFIDENCE.NORM, CONFIDENCE.T, EXPON.DIST, F.DIST, F.DIST.RT, F.INV, F.INV.RT, F.TEST, GAMMA, GAMMA.DIST, GAMMA.INV, GAMMALN, GAMMALN.PRECISE, HYPGEOM.DIST, LOGNORM.DIST, LOGNORM.INV, NEGBINOM.DIST, NORM.DIST, NORM.INV, NORM.S.DIST, NORM.S.INV, POISSON.DIST, T.DIST, T.DIST.2T, T.DIST.RT, T.INV, T.INV.2T, T.TEST, WEIBULL.DIST, Z.TEST

Dates and times DATE, DATEDIF, DATEVALUE, DAY, DAYS, EDATE, EOMONTH, HOUR, ISOWEEKNUM, MINUTE, MONTH, NETWORKDAYS, NOW, SECOND, TIME, TIMEVALUE, TODAY, WEEKDAY, WEEKNUM, WORKDAY, YEAR

Looking up CHOOSE, COLUMNS, HLOOKUP, INDEX, MATCH, ROWS, VLOOKUP, XLOOKUP

Logic AND, IF, IFERROR, NOT, OR

Text CONCAT, CONCATENATE, LEFT, LEN, LOWER, MID, RIGHT, TEXT, TRIM, UPPER

A view only link opens the sheet to be read, with Edit a copy to change it; it asks, it does not enforce, since anyone with the link could take the flag off. A password seals the link with AES-GCM in this browser: without it the link opens nothing, and a forgotten password cannot be recovered. Recent sheets are kept in this browser only.

The sheet lives in this page's link and nowhere else. Nothing is uploaded. A link holds what it carries in your browser history too, so keep secrets out of a sheet.