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

- 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.

- 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
- Click a cell and start typing, or press
F2orEnterto edit what is there. - Press
Enterto save and go down,Tabto save and go right,Escto cancel. When you started by typing, the arrow keys also save and move. - Start with
=to write a formula. See Write formulas. 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 orShift+ 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 + Spaceselects the row,Ctrl + Spacethe column,Ctrl + Aeverything. Ctrl+ arrow jumps to the edge of the data.Ctrl + Homegoes to A1,Ctrl + Endto the last used cell.PageUpandPageDownmove a screen at a time.Esccollapses 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 + Ccopies the selected range. Pasting it inside the workbook withCtrl + Vcopies values, formulas and formatting; formulas are adjusted to their new place (=A1*2copied one row down becomes=A2*2, while$A$1stays put).Ctrl + Xcuts: 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".
DeleteorBackspaceclears 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
- Select the cell or cells to repeat — for example
1and2, or two dates a week apart. - Drag the small square at the bottom-right corner of the selection (the fill handle) down or across.
- 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.