Forum Discussion
Unhiding the first column
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?
14 Replies
Why the heck this is so f... hard! It should have been just unhide.
- Unfortunately, this does not work for me. I am using office 365. Any other ideas?
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
I typed A1, hit enter, then used the Format option on the Home ribbon to select "unhide". Thanks for the suggestion though as it lead me to a way that worked for me.
- 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?
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
Thank you :)
- Yes I have both released frozen cells and tried if freezing would make the first column appear, but neither helped.
Did you check if you freezed panes?
Thank you for suggesting unfreezing rows/columns. Afterward, I was able to unhide the columns to the left.
Peter_Gourmand Thank you for your suggestion. I also faced similar problem and was struggling to solve it. The unfreeze thing worked. Thank You.
THANK YOU SO MUCH! That was it. Perfect!
