Hiding Rows and Columns
On some worksheets, you need to use rows or columns to hold data used in calculations, but you don't need to clutter up the rest of the worksheet by showing it. Click any cell within the row or column you want to hide (you don't need to select the entire row or column) and choose Format, Row, Hide or Format, Column, Hide.
To make a hidden row visible again, select cells in the row above and below the hidden row, and then choose Format, Row, Unhide. To display a hidden column, select cells in the columns to the left and right and choose Format, Column, Unhide.
If the first row or column of a worksheet is hidden, press F5 to open the Go To dialog box. Type A1 in the Reference box and click OK; then choose Format, Row (or ...
Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
