Sometimes you may wish to remove a row or column from view but not permanently delete it from your Excel worksheet. For instance, you may wish to print out only relevant rows or columns from your worksheet. Excel allows you to temporarily hide a row or column from view using the Hide command. When a row or column is hidden, note that the row heading or column heading disappears from view as well. Hidden objects can still perform and be included in calculations.
To unhide a column or row, you must first select the rows or columns adjacent to the hidden one(s) before using the unhide command
Hidden Row 5 Disappears from View
To Hide Columns
- Select the column or columns to be hidden.
- Right-Click and choose Hide from the pop-up menu.
To Hide Rows
- Select the row or rows to be hidden.
- Right-Click and choose Hide from the pop-up menu.
To Unhide Columns
- Select the columns to the left and right of the hidden one(s).
- Right-Click and choose Unhide from the pop-up menu.
To Unhide Rows
- Select the rows above and below of the hidden one(s).
- Right-Click and choose Unhide from the pop-up menu.
Similar Posts:
- Freezing and Unfreezing Rows and Columns in Excel
- Insert Rows and Columns in a Word 2007 Table
- Creating a Table in Excel
- Sorting the Contents of a Folder in Leopard
- Transpose Rows and Columns in Excel
- Creating a drop-down list in Excel
- Hide Zeros in Excel 2007
