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

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