Hiding a Row or Column in MS Excel

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!