Hiding a Row or Column in MS Excel
- by Carol Bratt on 20090115 @ 06:10PM EST | google it | send to friends
- Filed under Carol's Corner Office | (related terms: column, hide row, format row, format column, spreadsheet)
There may be occasions when you want to omit a column or row of data from a printed copy of your spreadsheet, but still have the rest of your spreadsheet in your favorite format.
Follow the steps below to learn how to hide a row or column:
- Select the column or row you would like to hide.
- Click Format | Column | Hide.
- To hide a row, click Format | Row | Hide.
Follow the steps below to unhide rows or columns:
- Select the columns or rows you on either side of the hidden column.
- Click on Format | Column | Unhide to unhide the column.
- To unhide a row, click on Format | Row | Unhide.
The column or row you hid earlier will now be visible.
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
