Professor Excel

Unhide All Rows or Columns in Excel at the Same Time

Many people love the “Hide” function for hiding rows or columns, as it is very easy to use:

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…
[…]