How Do I Hide the Pivot Table Editor in Google Sheets?
However, at This Point, There Really Is No Way to Hide the Pivot Table Editor in Google Sheets from View. Every Time You Select a Cell of Your Pivot Table, the...
However, at this point, there really is no way to hide the pivot table editor in Google Sheets from view. Every time you select a cell of your pivot table, the editor sidebar will appear, and there's not much that you can do other than to simply close it.
How do I hide the pivot table editor?
First option: use File > Share to assign the ownership of the spreadsheet to an account that does not mind seeing the pivot table editor. With the owner account, choose Data > Protect sheets and ranges and remove edit rights to the pivot table tab from everybody else.How do I view the pivot table editor in Google Sheets?
Add a pivot table from a suggestion
- In Sheets, open your spreadsheet that contains the source data.
- At the bottom right, click Explore .
- Scroll down to the Pivot Table section to see suggested pivot tables. Click More to see additional suggestions. ...
- Hover over the pivot table you want and click Insert pivot table .