Manage Sheets in Dashboards and Stories
Hiding, showing, and navigating to sheets helps you more easily manage workbooks and design dashboards.
Hide and show sheets
To streamline the editing process for large workbooks, hide and show sheets as you work.
For Viz in Tooltip, see Hide or show a Viz in Tooltip worksheet.
What sheets can I hide?
While editing a workbook, you can hide any sheet contained in a dashboard or story. (That includes dashboard sheets in stories.)
Sheets that aren't in a dashboard or story are always visible while editing workbooks. However, you can hide any sheet in workbooks you publish to Tableau Cloud or Tableau Desktop. See Comprehensive Steps to Publish a Workbook.
Hide or unhide all sheets
To hide all of a dashboard or story's sheets, right-click (Windows) or Control-click (macOS) the dashboard's tab at the bottom of the screen, and select Hide All Sheets. You can later select Unhide All Sheets if needed.
Hide an individual sheet
-
Look for the sheet in the tabs at the bottom of the screen. Or, if you're viewing a dashboard or story, look in the Sheets list at left:
-
Right-click (Windows) or Control-click (macOS) the sheet name, and select Hide Sheet.
Note: From the sheets list to the left of a dashboard or story, you can hide only sheets used in that particular dashboard or story. You can identify these sheets by the blue checkmark on the sheet icon.
Unhide an individual sheet
-
At the bottom of the screen, click the tab for the dashboard or story that contains the sheet. You can identify dashboards and stories by grid and book icons, respectively.
Note: If a story has a hidden dashboard that in turn has a hidden sheet, first go to the hidden dashboard from the story, and then to the hidden sheet from the dashboard.
-
In the list at left, right-click (Windows) or Control-click (macOS) the sheet, and clear the Hide Sheet checkbox.
Navigate between sheets, dashboards, and stories
Tableau lets you quickly navigate back and forth between sheets and related dashboards and stories, helping you better optimize the design of each.
Go from a dashboard or story to a sheet it contains
Tip: If a sheet is hidden, this technique temporarily shows it so you can get a closer look at it. The sheet is hidden again when you switch to another sheet.
Do either of the following:
-
On the dashboard itself, select the item that references the hidden sheet. Then click the drop-down arrow in the top left or right corner, and select Go to Sheet.
-
In the Sheets list to the left of the dashboard, click the icon to the right of the sheet name.
Go from a sheet to related dashboards and stories
To quickly go to dashboards and stories a sheet appears in, right-click the sheet tab and open the Used in menu.