When you create a new file, it is called a Workbook. This Workbook can be organized into multiple sheets that hold various information depending on the data type. To organize these sheets you can:
In a large workbook with multiple sheets, it can be helpful to control the number of sheet tabs that appear at the bottom of the workbook.
To view sheets:
To see all of the hidden sheets, click the hamburger icon at the bottom left of the page.
2. Select the sheet from the list the appears above the hamburger icon.
3. The sheet will now be visible in the bottom menu of the workbook.
Watch the video below to see how to view hidden sheets.
In a large workbook with multiple sheets, it can be helpful to control the number of sheet tabs that appear at the bottom of the workbook.
To hide sheets:
Click the triangle on the sheet that you want to hide.
Select hide sheet
Watch the video below to see how to view hidden sheets.
In a workbook, when a new sheet is created, the name is automatically Sheet1. The number increases each time a sheet is added. It is helpful to name sheets with a description of what it contains in order to efficiently navigate between sheets and to allow another user to quickly know an overview of what the sheet contains.
To name sheets:
Click the triangle on the sheet you want to name
Click Rename
Type the desired name in the sheet tab
Click enter
Watch the video below to see how to view hidden sheets.
In a large workbook, it can be helpful to color code the sheet tabs. You can change the color of each sheet. It is best practice to group similar sheets with the same color.
To the color of a sheet:
Click the triangle on the sheet you want to name
Change color
Select the desired color from the menu that appears at the right