activeblognews.com

From time to time, someone will send me a worksheet with hidden rows or columns. I usually don’t need to see the data, so of course I forget how to unhide it on the rare occasions when I do need to see it. It’s easy, and this is how we do it:

Highlight the row above and the row below the hidden row(s) - or the column to the left and to the right of the hidden column(s). Then, you can reveal the data in various ways:

• Press [Shift][Ctrl]0 (that’s a zero).
• Right-click the selection and choose Unhide.
• Choose Column (or Row) from the Format menu and then select Unhide. In Excel 2007, go to the Cells group on the Home tab, click Format, choose Hide & Unhide, and select Unhide Rows or Unhide Columns