Hiding a Row or Column in MS Excel

Dennis Faas's picture

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!

Rate this article: 
No votes yet