Add and Organize Sheets
To add a new sheet to your spreadsheet:
- Click the left panel to open the document outline.
- Click Add Before or Add After at the top of the panel.
You can add up to 1,000 individual sheets to one spreadsheet document. If you need to create a new spreadsheet, see Creating and Importing Spreadsheets.
You can move sections up and down in the hierarchy using the Move Up and Move Down icons in the document outline. To move a section up or down in level, use the Promote and Demote icons. You can also move sheets by clicking and dragging.
You can filter your sheets by keyword using the Filter option. Click the Show filter icon at the top of the panel and type your keywords in the Search bar. Press Enter on your keyboard to apply the filter.
Change Permissions for a Sheet
After adding a sheet to a document, you can change permissions for the individual sheet. To access sheet permissions, right-click the sheet name in the document outline and choose Sheet Permissions .
There are three types of permissions:
Owners have full rights to the document and can manage permissions
Editors can make changes and add new sheets
Viewers can look at a spreadsheet but can’t make any changes
The Permissions editor shows the current groups and collaborators. Use the search box or scroll down the list to find collaborators. You can use the Filter button in the upper right corner of the editor to view collaborators by permission level.
Click the radio button next to a collaborator’s name to give them appropriate access. To remove permission, hover over a collaborator’s name and click the that appears on the right.
To learn about permissions for an entire spreadsheet, see Collaboration in Spreadsheets.
Access Home from Spreadsheets
When you are working in a spreadsheet, you can return to Home at any point. Hover over the icons on the vertical bar on the far left to open a menu with all of the options available in Home.