Chapter 5 · 5.8
Managing sheets
Watch it in a short video
A spreadsheet (workbook) can have multiple sheets, like tabs in a folder. For example, one sheet per month, or a sheet with data and a sheet with calculations.
- Click the plus sign at the bottom to add a new sheet.
- Click the name of a sheet to go to it.
- Drag a sheet left or right to change the order.
Right-click a sheet (1) for more options: Insert, Delete, Rename, Move or copy, Hide, Protect and choosing a Tab color.
Calculating with another sheet
In a formula, you refer to a cell on another sheet using the sheet name followed by an exclamation mark: =Uitgaven!B10. If the name contains a space, put it in single quotation marks: ='Uitgaven 2027'!B10. The easiest way: type = and then click the other sheet and the cell.
Tip: you can read step by step how to create an overview of totals from multiple sheets in Een totaaloverzicht van meerdere werkbladen: uitgaven, inkomsten en saldo.