Work in the grid

Type, select, undo, copy and paste, fill a series, insert rows and freeze panes in the Sheets grid.

Type in cells, use typed columns, move around with the keyboard, undo, copy and paste, fill a series, and insert or delete rows.

Before you start: Can edit on Sheets to change anything. With Can view the grid is read-only.

The screen

The Sheets editor

  • Top bar: back button, Workbook name (click to rename), a status, collaborator avatars, Export .xlsx.
  • Toolbar: undo and redo, text formatting, alignment, number formats, sort, filter, freeze, notes, conditional formatting, charts, find and replace, and Keyboard shortcuts. On a phone it shows only the essentials — see Use Sheets on your phone. The toolbar
  • Formula bar: the selected cell's address and contents. Click it to edit.
  • Grid: columns A, B, C… and numbered rows. A new sheet starts with 26 columns. Extra empty columns fill the screen. They become real text columns when you type in them.
  • Status bar: for a selection of several cells, Sum, Average, Min, Max and Count. When a filter is on, it shows how many rows match.
  • Sheet tabs at the bottom.

Status in the top bar

Label Meaning
In memory The workbook is loaded for fast editing.
Loading into memory… It is being loaded. You can already work.
On disk Not loaded yet. Everything still works.
a message with Retry Loading failed. Click Retry.

Enter data

  1. Click a cell and start typing, or press F2 or Enter to edit what is there.
  2. Press Enter to save and go down, Tab to save and go right, Esc to cancel. When you started by typing, the arrow keys also save and move.
  3. Start with = to write a formula. See Write formulas.
  4. Ctrl + ; puts today's date in the cell.

Column types

Each column has a type that is fixed once the column exists.

Type What you can enter
Text Anything.
Number Numbers. Commas are ignored (1,250). Otherwise "not a number".
Currency Same as Number.
Date YYYY-MM-DD, a full timestamp, YYYY-MM-DD HH:MM, or DD/MM/YYYY. Otherwise "not a date (use YYYY-MM-DD)". Editing opens a date picker. A formula in a date column shows its result as a date.
Checkbox true, false, 1, 0, yes, no, y, n, on, off. Press Space or Enter or click to toggle.
Select One of the column's options (a pick list opens). Anything else: "not one of the select options".

A value that does not fit is refused and the cell is marked.

Select cells

  • Drag to select a range. Shift + click or Shift + arrows extend. Ctrl/Cmd + click adds another range.
  • Click a column letter to select the column; click or drag row numbers to select whole rows. Shift + Space selects the row, Ctrl + Space the column, Ctrl + A everything.
  • Ctrl + arrow jumps to the edge of the data. Ctrl + Home goes to A1, Ctrl + End to the last used cell. PageUp and PageDown move a screen at a time.
  • Esc collapses to one cell.

Undo and redo

Ctrl + Z undoes your last change, Ctrl + Y (or Ctrl + Shift + Z) redoes it — or use the arrows at the left of the toolbar. Undo covers cell edits, clearing, pasting, filling and formatting, up to 100 steps per sheet. It only undoes your changes.

Sorting, inserting or deleting rows or columns, and changing columns clear the undo history, because they move everything else.

Copy, cut, paste, clear

  • Ctrl + C copies the selected range. Pasting it inside the workbook with Ctrl + V copies values, formulas and formatting; formulas are adjusted to their new place (=A1*2 copied one row down becomes =A2*2, while $A$1 stays put).
  • Ctrl + X cuts: the cells move when you paste, and the original cells are cleared.
  • Text copied from another spreadsheet app pastes as plain values. You see "Pasted N cells".
  • Delete or Backspace clears every selected cell.
  • Right-click a cell for Cut, Copy, Paste, Clear contents, Insert note, inserting rows and columns, sorting and filtering by that cell, and Delete row.

Fill a series

  1. Select the cell or cells to repeat — for example 1 and 2, or two dates a week apart.
  2. Drag the small square at the bottom-right corner of the selection (the fill handle) down or across.
  3. Release. Numbers and dates with a steady step continue the series (1, 2 → 3, 4, 5). Anything else repeats. Formulas are adjusted for each new cell.

Ctrl + D fills the top row of the selection down; Ctrl + R fills the left column to the right.

Rows

  • Right-click a row number for Insert row above, Insert row below and Delete row.
  • To insert or delete several rows, select them by dragging over the row numbers first; the menu then reads Insert N above, Insert N below and Delete N. Deleting several rows asks you to confirm.
  • Inserting or deleting rows moves the rest and updates formulas that point to those rows. A formula pointing at a deleted row shows #REF!.

Freeze rows and columns

Keep headings in view while you scroll: click Freeze on the toolbar and choose Freeze 1 row, Freeze 2 rows or Freeze up to row N (up to 10 rows), and Freeze 1 column or Freeze up to column N (up to 5 columns). No frozen rows and No frozen columns undo it. Frozen panes are saved with the sheet, so everyone sees them.

Troubleshooting

Write failed The change was not saved. Try again.

not a number / not a date / not a checkbox value The text does not fit the column type. See the table above.

Your browser blocked reading the clipboard The right-click Paste needs clipboard permission. Press Ctrl + V instead.

Cell marked with an error Hover it to read the message.