Can't unhide a column

%3CLINGO-SUB%20id%3D%22lingo-sub-206325%22%20slang%3D%22en-US%22%3ECan't%20unhide%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-206325%22%20slang%3D%22en-US%22%3E%3CP%3EWindows%2010%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20column%20C%20which%20I%20hid%20last%20week%20now%20won't%20unhide.%20I've%20tried%20right-clicking%20unhide%2C%20select%20all%20unhide%2C%20visibility%2C%20reformatting%20all%20the%20column%20widths%3A%20nothing%20works.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-206325%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-206506%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20unhide%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-206506%22%20slang%3D%22en-US%22%3EIf%20you%20do%20this%3A%3CBR%20%2F%3EPress%20F5%2C%20type%20C%3AC%2C%20click%20OK%20and%20then%20select%20(Start%20tab)%20Format%2C%20Column%20width%20and%20set%20it%20to%20e.g.%2010%2C%20does%20it%20show%3F%3CBR%20%2F%3Eis%20View%2C%20Freeze%20panes%20set%20by%20any%20chance%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1526841%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20unhide%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1526841%22%20slang%3D%22en-US%22%3EI%20followed%20your%20suggestion%20and%20went%20to%20View.%20Freeze%20panes.%20Cleared%20all%20and%20voila!%20column%20A%20re-appeared.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2038768%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20unhide%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2038768%22%20slang%3D%22en-US%22%3E%3CP%3EKisses%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B-%20it%20was%20freeze%20panes%20for%20my%20file.%26nbsp%3B%20I%20would%20not%20have%20found%20it%20without%20this%20thread.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2259964%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20unhide%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2259964%22%20slang%3D%22en-US%22%3EFreeze%20Panes...great%20tip!%20It%20works%20for%20me%20too%20after%20far%20too%20much%20time%20scouring%20help%20threads.%20Thank%20you!!!%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2523758%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20unhide%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2523758%22%20slang%3D%22en-US%22%3EFor%20anyone%20else%20who%20this%20might%20not%20have%20worked%20for%2C%20chances%20are%20that%20the%20missing%20columns%20may%20have%20been%20minimized.%20With%20your%20mouse%2C%20try%20grabbing%20the%20bar%20along%20the%20left%20edge%20of%20the%20last%20column%20that%20is%20visible.%20Hold%20down%20the%20right%20mouse%20button%20(you%20will%20see%20a%20double%20arrow%20pop%20up)%20and%20drag%20it%20to%20the%20right.%20The%20missing%20columns%20should%20show%20up.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2681759%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20unhide%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2681759%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3BThanks%20a%20lot%2C%20unfreezing%20solved%20the%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2682424%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20unhide%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2682424%22%20slang%3D%22en-US%22%3EHi%2C%20Please%20check%20this%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2014%2F07%2F30%2Fexcel-unhide-columns%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2014%2F07%2F30%2Fexcel-unhide-columns%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

Windows 10

 

My column C which I hid last week now won't unhide. I've tried right-clicking unhide, select all unhide, visibility, reformatting all the column widths: nothing works.

7 Replies
If you do this:
Press F5, type C:C, click OK and then select (Start tab) Format, Column width and set it to e.g. 10, does it show?
is View, Freeze panes set by any chance?
I followed your suggestion and went to View. Freeze panes. Cleared all and voila! column A re-appeared.

Kisses @Jan Karel Pieterse - it was freeze panes for my file.  I would not have found it without this thread.

Freeze Panes...great tip! It works for me too after far too much time scouring help threads. Thank you!!!
For anyone else who this might not have worked for, chances are that the missing columns may have been minimized. With your mouse, try grabbing the bar along the left edge of the last column that is visible. Hold down the right mouse button (you will see a double arrow pop up) and drag it to the right. The missing columns should show up.

@Jan Karel Pieterse Thanks a lot, unfreezing solved the problem.