In Google Sheets multiple sheets can be created and used simultaneously. Learn all about using these sheets here.
A Google spreadsheet can contain one or more sheets. When working with a large amount of information, you can create multiple sheets to help organize your spreadsheet and make it easier to find information.
In this lesson, you'll learn how to create, rename, move, delete, and duplicate sheets.
When you create a new Google spreadsheet, it has one sheet, which is named Sheet1 by default. In the sheets toolbar located at the bottom of the window, you will see a tab for each sheet you have. To organize your spreadsheet and make it easier to navigate, you can create, rename, delete, move, and duplicate sheets.
Watch the video below to learn how to create and manage multiple sheets.
In our example, the sheets of our service log are organized by month. We'll create a new sheet in the log so data can be entered in the new month.
Alternatively, you can create an additional sheet by clicking Insert and selecting New sheet from the drop-down menu.
If you want to limit collaborators from editing specific sheets of your spreadsheet, you can protect these sheets by clicking the desired sheet tab and selecting Protect sheet... from the menu that appears.
To copy a sheet to another spreadsheet in Google Drive, click the tab of the sheet you want to copy, then select Copy to... from the menu that appears. Select the spreadsheet where you want to place the copy from the list that appears. A duplicate of the sheet will appear in the other spreadsheet.