Free Excel hidden sheets Add-in
   

Tactical solutions

Research projects

Microsoft Office

Multiple choice guessing

Services

Knowledge measurement audit

Item bank services

Item design course

Products

WaterMarker

iOTA

STASiS

ACiS

CaSelector

CaSCADE

Technical articles

Excel and Office RAQ

Free Excel Add-in

Free PowerPoint Add-in

Contact

Home page

Excel lets you hide worksheets within a workbook, which can be handy if for instance you want to conceal the workings of your spreadsheets, or want to keep the user interface clean and simple.

Fortunately, you can also unhide these sheets, but ONLY ONE AT A TIME. This can be a major frustration if you need to do this a lot, particularly since the command is buried a couple of levels down in the menu structure.

Our new add-in rectifies this problem and allows you to hide and unhide multiple sheets with ease from a simple form.

You can download the add-in here. Save it wherever you like (preferably in the add-ins folder, but it doesn't really matter) and then browse to the file from Tools-Addins in Excel and your new toolbar will be available.

We have an article you can read containing the source code which makes the add-in work. You can read it for free here.