Unhiding the first column

[StellaRJK]

I am used to hiding and unhiding columns, but now my excel sheet refuses to show me the first column! I have tried "select all + right click + unhide" and just "selecting the first visible column + right click + unhide" ...

Any good advice?

[#2]

Did you check if you freezed panes?

[#3]

Yes I have both released frozen cells and tried if freezing would make the first column appear, but neither helped.

[#4]

Hi @StellaRJK ,

(1) Select All(Ctrl+A) then

Home/Format/Hide and Unhide/unhide column(keyboard key :- Alt+H+O+U+L).

(2) Type A1 in Name Box & Select column(Ctrl+Space). use right click and unhide

[#5]

Thank you :)

[#6]

@StellaRJK 

Happy to help you.

regards

Naveen

[#7]

Worked perfectly. I have been having this problem intermittently for years.  Glad to have discovered the cause.  Thanks.

[#8]

THANK YOU SO MUCH! That was it.  Perfect!

@Peter_Gourmand 

[#9]

Unfortunately, this does not work for me. I am using office 365. Any other ideas?

[#10]

I can get as far as selecting (highlighted) the place where column A should show, but can't figure out what to right click on to get the unhide option. Nothing that I have tried gives me that option. Any other suggestions?

[#11]

@bbuddington 

As variant, locate mouse cursor close to hided column at top left and when it shows you are between columns

right click -> Unhide; or

hold left button and drag to the right

[#12]

@Peter_Gourmand Thank you for your suggestion. I also faced similar problem and was struggling to solve it. The unfreeze thing worked. Thank You.

[#13]

@Peter_Gourmand 

Thank you for suggesting unfreezing rows/columns.  Afterward, I was able to unhide the columns to the left.