Unhide Cells

The OAK4 | Workbook or Worksheet | Unhide Rows And Columns tool unhides all hidden rows and columns in either whole workbooks or a selection of worksheets from a workbook.

Why would you want to use it

When building a model people sometimes hide rows and columns so that they can concentrate on the pieces of the model they are currently working on without other pieces of the model getting in the way.  If a template model has been used as the basis of the new model that has been built then unnecessary parts of the template model may have been hidden.

The Unhide Rows And Columns command allows you to quickly unhide rows and columns so that you can see if there are any errors in the hidden sections.  In the case where a template model has been used you can check that the hidden sections are really not used in the new model.

How to use it

To unhide rows and columns in a selection of sheets within a workbook choose the Selected Worksheets option.  Then choose the workbook that contains the required worksheets from the list on the left and choose the required worksheets from the list on the right.

What you could do if you didn't have OAK

All rows and columns on a single worksheet can be unhidden by first selecting the whole worksheet by pressing Ctrl+A.  Then go to  Format | Row | Unhide  and then Format | Row | Unhide.  This means that hidden rows and columns must be unhidden one worksheet at a time.  With OAK’s Unhide Rows And Columns tool rows and columns can be unhidden on many worksheets at once.