Link to home
Start Free TrialLog in
Avatar of Conernesto
ConernestoFlag for United States of America

asked on

Unhide column A

How do I unhide column A in excel 2010?
Avatar of Alan
Alan
Flag of New Zealand image

Press F5 on your keyboard, then type in 'A1' and press Enter

This will take you to the (hidden) cell A1.

Now you can Format and Unhide that column:

Home - Cells - Format - Hide & Unhide - Unhide Columns


Alan.
With VBA:
ActiveSheet.Columns("A:A").Hidden = False
ASKER CERTIFIED SOLUTION
Avatar of M A
M A
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Was the column closed up to hide it?   Grab the column hidden like that by the right side of the column and drag it open.
Avatar of Conernesto

ASKER

Attached is my worksheet. I could not see column A after I did above. Please unhide this one and let me know how you did this.
Column-A-Hidden.xlsx
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you everyone for your help.
Errm.... thanks.

Alan.