2007 Microsoft® Office System Plain & Simple

Hiding Columns and Rows

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.

Hide Columns or Rows

1. Select the columns or rows that you want to hide.

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

Reveal Hidden Columns or Rows ...