Skip to main content

Work with sheets

Adding a new sheet

To add a new sheet, take the following steps:

  1. Choose a sheet tab by clicking on it

  2. Click the Add sheet button in the bottom toolbar

note

Note, that a new sheet will be added after the currently active sheet.

Add sheet

Removing a sheet

To remove a sheet from the spreadsheet, right-click the sheet tab and choose Delete.

note

Note, that a sheet can't be removed if it is the only sheet in the spreadsheet.

Remove sheet

Changing the active sheet

To change the currently active sheet, just click a different sheet tab with the mouse pointer.

Change active sheet

Renaming a sheet

To rename a sheet, right-click the sheet tab, click Rename, and type the new name.

Rename sheet

Cross-references between sheets

You can easily consolidate data from multiple sheets into a single one by using cross-referencing.
For that, take the following steps:

1. Type an equal sign (=) into a cell

2. Click the sheet tab you want to cross-reference and select the cell or range of cells

3. Finish typing the formula and press Enter

Using formulas