Manage multiple sheets

1. 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 1. Select the drop-down next to Sheet 1 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 drop-down and select Duplicate. The new sheet will have the exact same formatting and 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 of a hidden sheet to unhide it. To ensure that important data is not edited or deleted from the spreadsheet, choose Protect Sheet, or select Protected Sheets and Ranges from the data menu. The Protected Sheets and Ranges panel will appear on the right side of the sheet. Enter a description. To leave specific cells as editable, select the checkbox next to Accept Certain Cells, and select a range to be left unprotected. Select Set Permissions to set the editing permissions. Choose to either show a warning to those who attempt to edit the range, or restrict editing to a collaborator by typing their name or email address. Sheets will offer suggestions of people based on what is typed in the Add Editors field. Permissions can also be copied from another protected range. By default, the owner decides who can change ranges and sheets. Editors can protect ranges and sheets but cannot limit the access of the owner.

2. Let's practice!

Create Your Free Account

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Google Workspace End User: Google Sheets

BeginnerSkill Level

5.0+

1 reviews

This module covers the agenda. It also introduces students to On the Rise and the course business challenge.

Exercise 1: Course introduction Exercise 2: Agenda

In this module, we will look at the different ways to share your spreadsheets with others. You will learn how to add collaborators and assign them roles and permissions, and also learn how you can share your Google Sheets spreadsheet with a link. You will understand how to transfer ownership of your spreadsheets to another collaborator, track changes, and manage versions.

Exercise 1: Share your Google Sheets spreadsheets Exercise 2: Activity 7 explained Exercise 3: Activity 7 Explore sharing options Exercise 4: Quiz Question 1 Exercise 5: Quiz Question 2