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. |
|
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.

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

· 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.

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!!


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.
Comments
Leave a Reply





























