Enter and edit data

You can enter text, numbers, and formulas into any cell in Sheets, then edit or clear them at any time. Changes are saved automatically.

Type into a cell

1. Click the cell where you want to enter data. A colored outline shows it is selected.
2. Start typing. The cell opens for editing and the text appears as you type.
3. Press Enter to confirm and move to the next row.

To cancel what you have typed before confirming, press Escape. The cell returns to its previous contents.

Edit a cell you have already filled in

Select the cell, then do one of the following:

• Double-click the cell to place your cursor inside it.
• Press F2 to open the cell for editing at the end of its contents.
• Click the formula bar (the input area below the menu bar) and edit there.

While the cell is open for editing, the arrow keys move the cursor within the text rather than moving to a neighboring cell. Press Enter when you are done.

Add a line break inside a cell

Press Alt+Enter (Mac: ⌥+Enter) while a cell is open for editing. The cursor moves to a new line within the same cell. Press Enter on its own to confirm and move to the next row.

Clear cell contents

Select one or more cells, then press Delete or Backspace. The values and formulas are removed.

To clear contents from the right-click menu, right-click the selection and choose Clear contents. The same option is available under Edit → Delete → Clear contents.

Select a range of cells

• Click and drag to select a rectangle of cells.
• Shift+click to extend the selection to another cell.
• Shift+arrow keys to extend the selection one cell at a time.
• Click a column letter or row number to select the whole column or row.

Fill down or fill right

To copy the top row of a selection into the rows below it, or its left column into the columns to its right, select the range first (including the source cells), then:

• Press Ctrl+D (Mac: ⌘D) to fill down through the selected rows.
• Press Ctrl+R (Mac: ⌘R) to fill right across the selected columns.

Sheets copies each cell whole: its value or formula, formatting, borders, data validation, and conditional formatting. When filling formulas, Sheets adjusts relative cell references automatically. An empty source cell clears the cells it fills.

Undo and redo

• Ctrl+Z (Mac: ⌘Z) undoes the last change.
• Ctrl+Shift+Z (Mac: ⌘⇧Z) redoes it.

Both are also available under Edit → Undo and Edit → Redo.