When you create a worksheet, it sometimes contains columns and rows of data that aren’t relevant for every review or for every use of the worksheet, even though they’re important in various analyses. You can hide these columns and rows from view when they’re not needed and reveal them again when you or someone else wants to review or work with them.

Reveal Hidden Columns or Rows

1. Select the columns or rows that are adjacent to the hidden columns or rows.

2. Right-click one of the selected headers, and choose Unhide from the shortcut menu.

   

Tip

To make sure that you don’t accidentally distribute a workbook that contains information you don’t want to share with others, make sure there are no hidden rows or columns in your final version of the workbook. To check for hidden rows or columns, run the Document Inspector by pointing to Prepare on the Office menu and clicking Inspect Document in the gallery.

See Also

"Finalizing Your Document" for information about using the Document Inspector.