From the course: Introduction to Google Sheets

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Manage multiple sheets

Manage multiple sheets

A Google Sheets spreadsheet can have more than one sheet in order to organize data or to deal with large amounts of data. Every spreadsheet created in Google Sheets has a default sheet named sheet one. Select the dropdown next to sheet one to open the menu. The sheet can be duplicated, copied to a new or existing spreadsheet, renamed, protected, moved left or right, or it can even be hidden. To rename a sheet, use the menu, then choose rename or simply double click on the sheet name to edit it directly. Select all sheets to see the list of sheets in the spreadsheet. To add a new sheet, select add sheet. A new sheet will be added to the right of the current sheet. To move or reorder the sheets, click and drag the sheet tab to the left or right. To duplicate a sheet, click the dropdown and select duplicate. The new sheet will have the exact same formatting in data. Select hide from the menu to remove the tab from view. Select all sheets to reveal any hidden sheets and click on the name…

Contents