Microsoft Office Tutorials and References
In Depth Information
Hiding Columns or Rows
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.
Formulas that refer to data in hidden rows 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
resulting from filtering or outlines. In addition, the new AGGREGATE function has an
option to ignore hidden data in rows, even if the rows are hidden manually. Refer to
the Help system for information about these functions — which do a lot more than just
add numbers.
Hiding
To hide one or more columns, use any of these techniques:
h Select a cell in the column (or columns) to be hidden. Then choose Home
Cells
Format
Hide & Unhide
Hide Columns.
h Select entire columns and then right-click and choose Hide from the shortcut menu.
h 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:
h Select a cell in the row (or rows) to be hidden. Then choose Home
Cells
Format
Hide
& Unhide
Hide Rows.
h Select entire rows and then right-click and choose Hide from the shortcut menu.
h 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. Note that it’s a bit tricky
because you can’t select hidden rows or columns directly.
h 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.
 
Search JabSto ::




Custom Search