Home

Unhiding the first column

%3CLINGO-SUB%20id%3D%22lingo-sub-358070%22%20slang%3D%22en-US%22%3EUnhiding%20the%20first%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358070%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20used%20to%20hiding%20and%20unhiding%20columns%2C%20but%20now%20my%20excel%20sheet%20refuses%20to%20show%20me%20the%20first%26nbsp%3Bcolumn!%20I%20have%20tried%20%22select%20all%20%2B%20right%20click%20%2B%20unhide%22%20and%20just%20%22selecting%20the%20first%20visible%26nbsp%3Bcolumn%20%2B%20right%20click%20%2B%20unhide%22%20...%3C%2FP%3E%3CP%3EAny%20good%20advice%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-358070%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-358100%22%20slang%3D%22en-US%22%3ERe%3A%20Unhiding%20the%20first%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358100%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F292682%22%20target%3D%22_blank%22%3E%40StellaRJK%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHappy%20to%20help%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eregards%3C%2FP%3E%3CP%3ENaveen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-358096%22%20slang%3D%22en-US%22%3ERe%3A%20Unhiding%20the%20first%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358096%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20%3A)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-358093%22%20slang%3D%22en-US%22%3ERe%3A%20Unhiding%20the%20first%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358093%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F292682%22%20target%3D%22_blank%22%3E%40StellaRJK%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(1)%20Select%20All(Ctrl%2BA)%20then%3C%2FP%3E%3CP%3EHome%2FFormat%2FHide%20and%20Unhide%2Funhide%20column%3CSTRONG%3E(keyboard%20key%20%3A-%20Alt%2BH%2BO%2BU%2BL).%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(2)%20Type%20A1%20in%20Name%20Box%20%26amp%3B%20Select%20column(Ctrl%2BSpace).%20use%20right%20click%20and%20unhide%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20212px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F84652i21949E0C29CFD482%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Name%20Box.JPG%22%20title%3D%22Name%20Box.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-358080%22%20slang%3D%22en-US%22%3ERE%3A%20Unhiding%20the%20first%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358080%22%20slang%3D%22en-US%22%3EYes%20I%20have%20both%20released%20frozen%20cells%20and%20tried%20if%20freezing%20would%20make%20the%20first%20column%20appear%2C%20but%20neither%20helped.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-358078%22%20slang%3D%22en-US%22%3ERe%3A%20Unhiding%20the%20first%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358078%22%20slang%3D%22en-US%22%3E%3CP%3EDid%20you%20check%20if%20you%20freezed%20panes%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
StellaRJK
New Contributor

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?

5 Replies

Did you check if you freezed panes?

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

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

Name Box.JPG

Thank you :)

@StellaRJK 

 

Happy to help you.

 

regards

Naveen

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
33 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies