Hiding and Unhiding Rows

Excel allows you to easily hide a row, meaning it will not be shown on the display or printed when you print the worksheet. The row is not deleted; its height is simply reduced to 0. To hide a row, follow these steps:

1. Select any cell in the row (or rows) you want to hide.
2. Choose the Row option from the Format menu. This displays a submenu.
3. Choose the Hide option from the submenu. The rows disappear from the display.

When you hide rows in a worksheet, you will notice that the other rows are not renumbered. Instead, a thick bar appears in the row header area (at the left side of the screen) to indicate that there are hidden rows at that point.

1. Select the rows on either side of those that are hidden.
2. Choose the Row option from the Format menu. This displays a submenu.
3. Choose the Unhide option from the submenu. The previously hidden rows reappear on the display.