Datasheet

Hiding Columns or Rows
If you have data in a column or row that you don’t want to see, you can hide the column or
row. Doing this is often useful if you have formulas that provide intermediate calculations
and you don’t want them to appear in a report. Or, you may just want to hide unused rows
and columns so that you can focus only on the used area of the sheet.
NOTE
Formulas that refer to data in hidden rows or columns continue to function normally. An
exception is the SUBTOTAL function. If the first argument for SUBTOTAL is greater than
100, the SUBTOTAL function ignores the data in the hidden rows or columns. Refer to
the Help system for information about the arguments for SUBTOTAL. (It does lots more
than just sum.)
Hiding
To hide one or more columns, use any of these techniques:
•
Select a cell in the column (or columns) to be hidden. Then choose Home ➪ Cells ➪
Format ➪ Hide & Unhide ➪ Hide Columns.
•
Select entire columns, and then right-click and choose Hide from the shortcut menu.
•
Select a cell in the column (or columns) to hide, and press Ctrl+0 (that’s a zero).
To hide one or more rows, use any of these methods:
•
Select a cell in the row(or rows) to be hidden. Then choose Home ➪ Cells ➪ Format ➪
Hide & Unhide ➪ Hide Rows.
•
Select entire rows, and then right-click and choose Hide from the shortcut menu.
•
Select a cell in the row (or rows) to be hidden, and press Ctrl+9.
Unhiding
That which is hidden also needs to be unhidden.
To unhide one or more hidden columns, use any of these techniques:
•
Select a range that consists of cells to the left and to the right of the hidden columns.
Then choose Home ➪ Cells ➪ Format ➪ Hide & Unhide ➪ Unhide Columns.
•
Select entire columns to the left and to the right of the hidden columns, and then right-
click and choose Unhide from the shortcut menu.
Tip 16: Hiding Columns or Rows
46
04_137666 ch01.qxp 5/22/07 7:31 PM Page 46