MIP Logo

Tableau Tips: how to unhide what’s hidden

This post was originally published on The Data School blog between 2018 and July 2025, before our program was renamed to MIP’s Analytics Career Accelerator. References throughout this article to “The Data School” or “DS” all refer to what is now MIP’s Analytics Career Accelerator. The program, its people, and its commitment to launching outstanding analytics careers remain the same – just under a new name.

If you are having trouble viewing this article, please report it here. 

It’s quite easy to hide things in Tableau (both purposefully and by accident), however, finding them again is another matter. This blog is to help you find something you have accidentally lost or would like to unhide in Tableau.

 

Finding hidden labels in Tableau

Did you accidently hide labels that you want to get back again? To re-show or unhide hidden labels, go to “Analysis” in the top menu, go down to “Table Layout” and select either “Show Field Labels for Rows” or “Show Field Labels for Columns” – whichever is relevant to your situation.

 

Finding hidden headers in Tableau

Have you accidently hidden headers that you want to show? To unhide hidden headers for a particular visualisation, go to the relevant pill for that visualisation (in the rows or columns shelf). Then right-click or click on the small down arrow on that pill, from the menu here, you can then select “Show Header”. If the “Show Header” option already has a tick next to it, you have accidentally selected the wrong pill, try again with the correct pill.

 

Tableau Sidebar disappeared

Did you accidentally lose the entire sidebar? This can be a stressful situation as it isn’t obvious how to get it back.  Not to fear, you can get this back again by

 

Extra: Where is my data extract in Tableau?

Can’t find your data extract? When in the normal sheet view, see the data source at the top of the Data sidebar to the left. Right click on the data source, hover on “Extract” and then click on “Properties” and you will see the location of where the file is saved.

 

Share this post