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

@StellaRJK 

 

Happy to help you.

 

regards

Naveen

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies