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:

The tab menu with Rename, Duplicate, Colour, Hide sheet, Export CSV and Delete

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

  1. Click the Add column button at the end of the header row.
  2. Enter a Label (for example "Amount") and choose a Type: Text, Number, Currency, Date, Checkbox or Select.
  3. 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 ⋯:

The column menu

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.