Skip to Content
Contact us

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 SUM of 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

ErrorWhat it usually means
#DIV/0!The formula divides by zero or an empty cell
#N/AA 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

ActionShortcut
Jump to the edge of your dataCtrl + arrow keys
Go to the first or last cellCtrl + Home or End
Select the whole column or rowCtrl + Space or Shift + Space
Select allCtrl + A
Edit a cellF2
Finish and stay in the cellCtrl + Enter
Bold, italic, underlineCtrl + B, I, U
Fill downCtrl + D
Find / replaceCtrl + F / Ctrl + H
AutoSumAlt + =
Insert or delete rows or columnsCtrl + Alt + = or -
Add a commentCtrl + Alt + M
Zoom in / outCtrl + = / 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