It is quite easy to show or hide columns in Excel. Simply select a column, and press Control + 0 . The column is hidden from the view. You can make it out because of a dark line separating the columns. If you hide the B column, you will only see column A & Column C, and it is apparent that column B is hidden.
To unhide, simply select both column A & Column C. Then right click and select Unhide. Column B is brought back into view.
This works great most of the time. And it works in showing or hiding rows too.
Want to Improve Your Excel Skills?
Learn the Key Features of Excel Quickly & Easily, by Joining the
Online Training on Basic / Intermediate Excel.
To Get Most out of Excel, Learn the Pivot Table techniques in our
Pivot Table Masterclass Training!
But the problem arises when you want to hide the first column – Column A. Now it is difficult to select 2 adjacent columns, and you are unable to Unhide Column A.
Steps to Display the Hidden First Column (Column A) in Excel
- Press F5. The Go To dialog box will popup.
- Key in the cell A1 in Reference, and press Enter.
- The cursor would have moved to the cell A1, even if you can not see it. Do not worry.
- Now go to the Home Tab (in Excel 2007, 10 & 2013)
- Click on Format button – it is near the far end of the screen… toward the right side of the ribbon.
- Choose Visibility > Hide & Unhide. Then select to Unhide Columns.
Unhide columns or Rows in Excel - Voila! You will now be able to see the column A. It has been un-hidden.
It is a simple trick. Excel is all about simple tips and tricks… The more you practice, the more you try, the more gold shall ye find!
Cheers,
Vinai Prakash
Are you facing any problem in using Excel? Any Question?
You have come to the right place. Tell us your needs. We’ll be glad to help you!
