UnHiding/collasping Columns

%3CLINGO-SUB%20id%3D%22lingo-sub-2356017%22%20slang%3D%22en-US%22%3EUnHiding%2Fcollasping%20Columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2356017%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20to%20stop%20a%20spreadsheet%20from%20collapsing%20on%20me.%26nbsp%3B%20I%20have%20read%20the%20directions%20but%20still%20no%20success.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202021-05-14%20at%203.00.16%20PM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280792i1CB3908A5A26996F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202021-05-14%20at%203.00.16%20PM.png%22%20alt%3D%22Screen%20Shot%202021-05-14%20at%203.00.16%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2356017%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2356070%22%20slang%3D%22en-US%22%3ERe%3A%20UnHiding%2Fcollasping%20Columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2356070%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1054210%22%20target%3D%22_blank%22%3E%4024ktBrat%3C%2FA%3E%26nbsp%3BWhat%20do%20you%20mean%20by%20%22the%20spreadsheet%20.....%20collapsing%20on%20me%22%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2356088%22%20slang%3D%22en-US%22%3ERe%3A%20UnHiding%2Fcollasping%20Columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2356088%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20spread%20sheet%20has%208%20Columns%20in%20total%2C%20and%20the%20last%20three%20columns%20go%20into%20hiding%20and%20I%20must%20physically%20open%20them%20up%20each%20time.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I need help to stop a spreadsheet from collapsing on me.  I have read the directions but still no success.

Screen Shot 2021-05-14 at 3.00.16 PM.png

4 Replies

@24ktBrat What do you mean by "the spreadsheet ..... collapsing on me"?

@Riny_van_Eekelen 

 

The spread sheet has 8 Columns in total, and the last three columns go into hiding and I must physically open them up each time. 

 

@24ktBrat Sorry, never seen that happening before.

Could it be a macro that hides the columns when the workbook is opened?

Try opening the workbook without triggering the open event code (click on file/open, locate your file, then hold down the shift key before you select the file from the recent file list or click the open button if you use the file open dialog box and hold the shift key down until the file is completely loaded).