Hiding and Unhiding Rows and Columns

When you hide a row or column the data still remains in your workbook, but it is no longer displayed onscreen and is not part of the printed workbook. Hiding rows can be helpful when you want to print a copy of your workbook for others, but do not want to share all the information contained in your workbook. At any time, you can choose to "unhide" a row or column, which will redisplay the row or column.

To hide a row or column:

1. Select the row or column you want to hide.
2. Click the Format menu, point to Row or Column, and select Hide.

To unhide a row or column:

1. Select the rows or columns on either side of the row or column you want to unhide.
2. Click the Format menu, point to Row or Column, and select Unhide.

Another way to hide a column or row is to select the row or column, then right-click and select Hide. To unhide a column or row, first select the columns or rows on either side of the hidden one; then right-click and select Unhide.