Enter data and formulas
Type in cells, write formulas with about 290 functions, fill and copy data, and fix formula errors
Enter data
Select a cell and start typing. Press Enter to move down or Tab to move right. Press F2 to change what's in a cell, Alt + Enter for a new line inside a cell, and Esc to cancel. Delete clears the selected cells.
Dates, times and numbers follow your browser's language settings, such as the order of the day and month.
Write a formula
Start with =
Select a cell and type =, followed by a formula, such as =SUM(B5:B7).
Check the result
As you type, the formula bar shows the result. Click cells or drag over a range to add them to the formula. Press F4 to switch a reference between relative and absolute, such as B5 and $B$5.
Press Enter
The cell shows the result. Select it to see the formula in the formula bar.
To refer to another tab, write its name first, such as =Budget!B8.
Functions
Sheets has about 290 functions in these groups: Math, Statistics, Logic, Text, Date and Time, Lookup, Financial, Information and Engineering. They include SUM, SUMIFS, AVERAGE, IF, IFS, XLOOKUP, VLOOKUP, INDEX, MATCH, FILTER, SORT, UNIQUE, TEXTJOIN, TODAY, NETWORKDAYS, PMT and NPV.
Choose Insert Function (fx) next to the formula bar to search for a function by name or browse by group. Functions that return several values, such as FILTER and SORT, spill into the cells next to them.
Quick sums and dates
- AutoSum (on the Insert tab, or Alt + =) adds a
SUMof the cells above or beside. - Ctrl + ; adds today's date, and Ctrl + Shift + ; adds the time.
To see every formula instead of its result, choose View › Formulas, or press Ctrl + `.
Fill, move and copy
- Fill: drag the small square at the corner of the selection. Double-click it to fill down to the end of your data, or press Ctrl + D.
- Move: drag the edge of the selection. Hold Ctrl or Alt while you drag to copy instead.
- Paste Special: right-click and choose Values Only, Formatting Only or Formulas Only.
Formula errors
| Error | What it usually means |
|---|---|
#DIV/0! | The formula divides by zero or an empty cell |
#N/A | A lookup didn't find what it was looking for |
#NAME? | A function or name is misspelt |
#REF! | The formula refers to a cell that no longer exists |
#VALUE! | A value is the wrong type, such as text where a number should be |
#NUM! | A number is out of range |
#SPILL! | Something is in the way of a result that spills into other cells |
#CIRC! | The formula refers to itself |
Keyboard shortcuts
| Action | Shortcut |
|---|---|
| Jump to the edge of your data | Ctrl + arrow keys |
| Go to the first or last cell | Ctrl + Home or End |
| Select the whole column or row | Ctrl + Space or Shift + Space |
| Select all | Ctrl + A |
| Edit a cell | F2 |
| Finish and stay in the cell | Ctrl + Enter |
| Bold, italic, underline | Ctrl + B, I, U |
| Fill down | Ctrl + D |
| Find / replace | Ctrl + F / Ctrl + H |
| AutoSum | Alt + = |
| Insert or delete rows or columns | Ctrl + Alt + = or - |
| Add a comment | Ctrl + Alt + M |
| Zoom in / out | Ctrl + = / Ctrl + - |
Limits
Each tab can have up to 1,048,576 rows and 16,384 columns, with up to 200,000 cells filled in. A cell can hold up to 32,767 characters.
Last updated on 13 November 2026