Hiding a Row or Column in MS Excel
Hiding a Row or Column in MS Excel
Submitted by Dennis Faas on Thu, 01/15/2009 - 08:00
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:
Category:
Need Help? Ask!

My name is Dennis Faas and I am a senior systems administrator and IT technical analyst specializing in cyber crimes (sextortion / blackmail / tech support scams) with over 30 years experience; I also run this website! If you need technical assistance , I can help. Click here to email me now; optionally, you can review my resume here. You can also read how I can fix your computer over the Internet (also includes user reviews).

My name is Dennis Faas and I am a senior systems administrator and IT technical analyst specializing in cyber crimes (sextortion / blackmail / tech support scams) with over 30 years experience; I also run this website! If you need technical assistance , I can help. Click here to email me now; optionally, you can review my resume here. You can also read how I can fix your computer over the Internet (also includes user reviews).
We are BBB Accredited
We are BBB accredited (A+ rating), celebrating 21 years of excellence! Click to view our rating on the BBB.