Section 13. Working with Multiple Sheets

Like Excel, Google Spreadsheets lets you work with multiple sheets (Google calls them tabs) within a single spreadsheet file. Unlike Excel, which always starts with three sheets per spreadsheet, Google defaults to a single sheet. You can then add additional sheets to this first sheet.

Adding New Sheets

To add a new sheet to your spreadsheet, all you have to do is click the Add Sheet button at the bottom of the main spreadsheet window. To switch to a different sheet, just click its link, as shown in Figure 38.

Figure 38 Multiple sheets within a single spreadsheet file.

Renaming Sheets

By default, Google names its sheets Sheet1, Sheet2, Sheet3, and so forth. If you'd like a somewhat more descriptive name for a sheet, follow these steps:

1. Click a sheet link to make it the active sheet.
2. Click the tab for the active sheet; this displays a pop-up menu, as shown in Figure 39.

   Figure 39 Renaming a sheet.

   

3. Click Rename.
4. When prompted, enter a new name for the sheet, and then click OK.

Deleting Sheets

If you add a sheet that you later don't need, it's easy to delete it. Just follow these steps:

1. Click the sheet link for the sheet you want to delete.
2. Click the tab for the active sheet; this displays a pop-up menu.
3. Click Delete.