One of the great features of Excel is that we can hide individual columns, groups of columns and even multiple groups of columns. Similarly, we can hide rows.
For example, to hide Columns E and F, just left-click and drag from the E header over the E column to the F header over column F. Then, right-click in the selected E-F header, and select Hide from the popup context menu.
When we want to see hidden columns again, the Unhide command is used.
Continuing the same example, left-click on the D header (or any header before the hidden columns) and drag over the hidden columns to the column to their right (G in this case). Right-click in the selected D-G headers and select Unhide.
That’s all there is to hiding and unhiding columns.
But, what happens if you’ve hidden column A? There’s no column at the left for you to select and drag. How can we unhide Column A?
That’s where a non-obvious feature of Excel comes into play.
The box at the intersection of the Column letters and Row numbers is the key. If you click on that box, you’ll select all rows and columns.
Once they’re selected, just right-click on any of the displayed column letters. That will display the popup Context Menu. Select Unhide from the menu, and you’re done.