This will open up a dialogue box listing all worksheets that are currently hidden, just select the sheet that you want to unhide and click OK…Īs above, make sure you’re currently in the worksheet that you want to hide, then just right click on the Sheet name – in this example it’s Lists, and select Hide…Īnd that’s it, Lists becomes hidden! To unhide, again just right click the mouse on any sheet name, and choose Unhide. To unhide any hidden worksheets go to Cells section on the Home tab of the ribbon, click on Format, choose Hide & Unhide and select Unhide Sheet… If you want to hide more than 1 worksheet, click on the first worksheet you want to hide, then hold down Ctrl and click on the tabs of the other worksheets you want to hide and follow the above steps. Then select Hide Sheet to hide the current worksheet… Make sure you’re in the worksheet you want to hide (if you’re not then just click on the tab of the worksheet you want to hide)…Ĭlick on the Home tab in the ribbon, and go to the Cells section…Ĭlick on the Format drop down arrow, and choose Hide & Unhide in the Visibility section… In my example I have 3 sheets called Sales, Purchases and Lists. A step by step guide is below the video too ?
#How to unhide all sheets in excel at once how to
This short video will show you how to do this in version 2007 / 2010. Hiding the sheet will have no effect on any formulas or references and data contained in that sheet can still be used in other worksheets. For example, one of the sheets may contain the lists that are being used for the drop down data, which you don’t need to see. When working in a spreadsheet there may be a time when you don’t necessarily want to see all of the sheets.