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.

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 :)

Highlighted

@StellaRJK 

 

Happy to help you.

 

regards

Naveen

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