Unhide Multiple Sheets in Excel

I recently had a need to unhide multiple sheets in Excel (maybe you call them tabs). Whoever sent me the original file had decided to spread their data out over so many extra sheets that it would have taken almost literally minutes to unhide them all. Naturally, I wasted even more time looking for a way to automate this process.

You can use the reverse of the above to hide the data sheets again by hiding them first and saving the view as “No data” or something. The only trouble with this method of revealing all your hidden Excel tabs is that it needs to be repeated for each new file. The following method can help with this.

To add this to a new macro, go to the Developer tab, then Macros, then create a new one. Make sure to create it in your Personal.xlsb so that it’s universally available.

Paste the code in and assign a keyboard shortcut (and/or add it to the ribbon).

There you go. I haven’t gone into too much detail here because both the sites linked above are great, I just thought I’d summarise the two methods of unhiding sheets together. I seem to recall an Excel plugin that would unhide multiple sheets in Excel — this was even easier than the above — but I can’t for the life of me remember the name, other than I think it was something like “Brian’s Excel Tab Unhider”, but I can’t find that through Google. It’d be great if someone could point it out to me again…

Choose Custom Views on the View tab or menu.Click Add, and then type a name for your custom view, such as All Sheets, and then click OK. Next, hide any worksheets as needed and then create a second view titled Presentation View, or a name of your choosing.