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 - Google Sheets Tutorial
From the course: Introduction to Google 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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.