I have, on occasion, become the recipient of an MS Excel workbook that has hidden rows or columns. Mind you, it doesn’t happen often but when it does it can be a real problem because I don’t always remember how to unhide them and as you all know, I hate wasting time floundering around trying to find a resolution.
Follow the steps below to learn how to unhid rows and columns:
- Highlight the row above and the row below the hidden row(s), or the column to the left and right of the hidden column(s).
There are a couple of methods to reveal the hidden rows and columns:
- Click on Shift + Ctrl + zero.
- Right-click your selection and select Unhide.
- Click on Format | Column (or Row) and select Unhide.
- In version 2007, in the Cells group on the Home tab, clcik Hide & Unhide and select Unhide Rows or Unhide Columns.
Very simple eh?