Tabs and columns
Add, rename, colour, hide, duplicate and reorder sheets; insert, resize, hide and delete columns.
Add, rename, colour, hide, duplicate and reorder sheets (tabs), and insert, resize, hide and delete columns.
Before you start: Can edit on Sheets. Anyone who can open the workbook can use Export CSV on a tab.
Sheets (tabs)
The tabs run along the bottom of the editor.
Add — click + (Add sheet). A new sheet named Sheet2, Sheet3 and so on appears.
Reorder — drag a tab left or right.
The tab menu — right-click a tab, or click the ⋯ next to its name:

| Item | What it does |
|---|---|
| Rename | Rename it (double-clicking the tab also works). Formulas that point to the old name are updated. |
| Duplicate | Copies the sheet — values, formulas, formatting, charts and settings — into a new tab beside it, named " (copy)". A copy of a record-linked sheet is a plain sheet. |
| Colour… | Gives the tab a coloured underline, or None. |
| Hide sheet | Hides the tab. The tab menu then lists Hidden sheets with Show to bring one back. |
| Protect sheet… | Stops people other than workbook managers (and anyone you name) changing the sheet. See Protect sheets and ranges. |
| Export CSV | Downloads the sheet. See Import and export. |
| Delete | Confirm "Delete "" and everything on it?". Only shown when the workbook has more than one sheet. |
Next to + there is Import CSV.
A sheet name must be unique in the workbook (not case sensitive): "a tab named "x" exists". A workbook holds up to 20 sheets: "tab limit reached".
Columns
Add at the end
- Click the Add column button at the end of the header row.
- Enter a Label (for example "Amount") and choose a Type: Text, Number, Currency, Date, Checkbox or Select.
- Click Add.
The type cannot be changed afterwards. Typing into an empty ghost column past the last one creates a Text column for you.
The column menu — right-click a column header, or hover it and click its ⋯:

| Item | What it does |
|---|---|
| Rename | Change the column's Label. |
| Insert column left / Insert column right | Adds a Text column there. Formulas that point at columns to the right are updated. |
| Hide column | Hides it from view. Show N hidden columns in the menu brings them back. |
| Sort A → Z / Sort Z → A | Sorts the sheet by this column. See Sort, filter and find. |
| Filter… | Opens this column's filter. |
| Data validation… | Limits what the column accepts. See Data validation. |
| Delete column | Confirm "Delete column and its data? Formulas that point at it will show #REF!." It cannot be undone. |
Resize — drag the right edge of a column header. The width is saved for everyone.
Important: deleting a column removes its data, and formulas that used it show
#REF!.
A sheet holds up to 200 columns.
Tips
- To change a column's type, add a new column of the right type and copy the data across.
- Columns that come from a computed record field are greyed out and cannot be edited.
- Colour the tabs of summary sheets so people find them quickly.