How to unhide multiple tabs in excel

Microsoft Excel offers a very interesting way to unhide multiple sheets. We need to have multiple hidden sheets first in order to unhide them. We can then perform the below mentioned way to unhide sheets in excel:

We’ll learn about this methodology step by step.

Unhide sheets in excel:

Step-1: Having multiple hidden sheets in excel 

To do this yourself, please follow the steps described below;

– Open the desired Excel workbook, and make sure there are at least 2 hidden sheets.

Step-2: Viewing the unhide option

– Now right click on any of the sheets and select the “Unhide” option.

Step-3: Hidden sheets appear

– A dialogue box will appear to list all the hidden sheets.

Step-4: Selecting multiple sheets to unhide

– Now press the CTRL key, and click on as many sheets you want to unhide, and then press “OK”.

Final Image: Sheets have been unhidden

– All the selected sheets have been unhidden