Professor Excel
unhide, worksheets, all, excel, at once

Unhide All Hidden and Very Hidden Worksheets in Excel at Once

Unhiding hidden worksheets in Excel can be troublesome, especially if there are many hidden worksheets in your workbook. Usually, you would right click on any worksheet name on the bottom of the window and press “Unhide”. You can then choose one (and only one) worksheet at the same time for unhiding. After unhiding three worksheets like this, you will start feeling annoyed. After 10, you are going to hate Excel…
[…]

How to Get the Name of an Excel Worksheet

Often, you need to display and work with the sheet name, for example if you are working with the ‘INDIRECT’-formula. If you don’t want to type the sheet name manually – which is very unstable – there are three ways to get a sheet name:
[…]