A Cool MS Excel Trick for Hiding and Unhiding a Row or Column.

Posted on February 25, 2008
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

Here are a few posts the other readers recommend you check out.

Computer Tips, Tricks, Tweaks and Tutorials - A Cool MS Excel Trick for Hiding and Unhiding a Row or Column.

Hi folks, I hope you all had a great weekend!! And I hope your all ready for this week’s Tips and Tricks because I have some great ones for you lined-up. I was thinking of starting the week with a cool Microsoft Excel Trick. Normally we are talking about formulas but today’s Trick is about the use of a option that you probably use very much.

Today’s article is about the use of the hide and unhide option of MS Excel.

Most of us know that if you select a column or a row by clicking on the letter or digit that you can hide the column or row by right clicking on one of the related cells and then selecting the option hide. And Unhiding works the same with right click.

What most of us don’t know is this: let’s say you are hiding column B, C, D and E.

Excel-tip-trick-pic1

And you need to unhide one of those columns that you don’t necessarily need to unhide those four columns.

If you want to unhide one single column or row in Excel you have to follow the next steps.

· Put the cursor in the name box next to the formula bar.

· Type in one cell number of the column that you want to unhide. I’m now typing in B1 for unhiding column B.

· And press ENTER

Excel-tip-trick-pic2

· Then go to Format

· Select Hide & Unhide

· And click on Unhide Columns

And you’re done; this is how you unhide one single column in MS Excel.

Excel-tip-trick-pic4

This works the same for exactly the same if you want to unhide one single row. I hope you all enjoyed this Cool Excel Trick. See you tomorrow!!

Do you want to see more? This is related...

Did you ever thought about publishing your own eBook or PDF report?

Invite your friends to the World of Office.

Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 10 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!

If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.