Home

Problem selecting 2 columns

%3CLINGO-SUB%20id%3D%22lingo-sub-1099172%22%20slang%3D%22en-US%22%3EProblem%20selecting%202%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1099172%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20problems%20selecting%20just%20two%20columns%20(AI%26amp%3BAU)%20so%20i%20can%20unhide%20the%20columns%20between%20them.%20It%20worked%20perfectly%202%20days%20ago%20but%20when%20i%20came%20in%20yesterday%20i%20started%20having%20this%20issue.%20Once%20i%20select%20the%20two%20columns%20it%20automatically%20selects%20all%20columns%20from%20(A%20to%20AU).%20I%20have%20tried%20multiple%20ways%20%22click%20and%20drag%2C%20click%20then%20shift%2Bclick%2C%20click%20then%20ctrl%2Bclick)%20and%20it%20always%20selects%20all%20the%20columns%20again.%20I%20can%20go%20to%20any%20other%20computer%20in%20my%20office%20and%20open%20the%20same%20files%20and%20it%20works%20perfectly%2C%20only%20(AI%26amp%3BAU)%20get%20selected%20and%20I%20can%20unhide%20the%20columns.%20I%20was%20thinking%20it%20was%20a%20glitch%20in%20Excel%20so%20I%20uninstalled%20and%20reinstalled%20office%20365%20but%20the%20problem%20remained.%20Any%20help%20would%20be%20great.%20I%20am%20posting%202%20pictures%20to%20show%20what%20I%20mean.%20First%20is%20my%20laptop%20selection%2C%20the%20second%20is%20from%20another%20laptop%20in%20my%20office.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F164517iFCF60F31CF40619E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22My%20Lapto_LI.jpg%22%20title%3D%22My%20Lapto_LI.jpg%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EMy%20laptop%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F164518i689B0681D4804839%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Other%20Lapto_LI.jpg%22%20title%3D%22Other%20Lapto_LI.jpg%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EOther%20laptop%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1099172%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1099326%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20selecting%202%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1099326%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20you%20upload%20a%20sample%20file%20to%20test%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1099342%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20selecting%202%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1099342%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F512071%22%20target%3D%22_blank%22%3E%40Reese0411%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOn%20these%20two%20laptops%20do%20you%20have%20exactly%20the%20same%20version%2Fbuild%23%20of%20the%20Office%20or%20they%20are%20different%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1099517%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20selecting%202%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1099517%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3BAttached%20is%20one%20sample%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1099536%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20selecting%202%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1099536%22%20slang%3D%22en-US%22%3E%3CP%3EThey%20use%20to%20be%20the%20same%20version%2Fbuild%20number.%20But%20when%20i%20uninstalled%20and%20reinstalled%20to%20try%20to%20fix%20the%20problem%20it%20installed%20a%20newer%20version.%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20465px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F164559i22FAAD0B4093ED9A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1099543%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20selecting%202%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1099543%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F512071%22%20target%3D%22_blank%22%3E%40Reese0411%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhy%20I%20asked%20that%20was%20a%20bug%20with%20related%20issue%20in%20some%20builds.%20Do%20you%20have%20the%20same%20on%20updated%20version%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1099548%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20selecting%202%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1099548%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20updated%20version%20has%20the%20same%20issue.%20It%20seems%20to%20be%20related%20to%20the%20a%20couple%20rows%20are%20merged%20across%20the%20column's.%20If%20i%20was%20to%20unmerge%20the%20rows%20then%20I%20can%20select%20columns%20just%20fine.%20But%20why%20can%20I%20do%20it%20on%20every%20other%20computer%20in%20my%20office%20just%20fine%20without%20having%20to%20unmerge%20the%20rows%3F%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1099619%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20selecting%202%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1099619%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F512071%22%20target%3D%22_blank%22%3E%40Reese0411%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHave%20no%20idea%20-%20same%20build%2C%20same%20file%2C%20it%20shall%20be%20the%20same%20behavior.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20general%20it's%20better%20to%20avoid%20merged%20cells%20at%20all.%20Could%20you%20lease%20check%20on%20attached%20file%2C%20I%20removed%20merged%20cells%20and%20change%20formatting%20on%20Center%20Across%20Selection%20instead.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Reese0411
New Contributor

I am having problems selecting just two columns (AI&AU) so i can unhide the columns between them. It worked perfectly 2 days ago but when i came in yesterday i started having this issue. Once i select the two columns it automatically selects all columns from (A to AU). I have tried multiple ways "click and drag, click then shift+click, click then ctrl+click) and it always selects all the columns again. I can go to any other computer in my office and open the same files and it works perfectly, only (AI&AU) get selected and I can unhide the columns. I was thinking it was a glitch in Excel so I uninstalled and reinstalled office 365 but the problem remained. Any help would be great. I am posting 2 pictures to show what I mean. First is my laptop selection, the second is from another laptop in my office.

 

My laptopMy laptopOther laptopOther laptop

7 Replies
Highlighted
Hello,

Can you upload a sample file to test
Highlighted

@Reese0411 

On these two laptops do you have exactly the same version/build# of the Office or they are different?

Highlighted

@Abiola1 Attached is one sample file.

Highlighted

They use to be the same version/build number. But when i uninstalled and reinstalled to try to fix the problem it installed a newer version. Capture.PNG @Sergei Baklan 

Highlighted

@Reese0411 

Why I asked that was a bug with related issue in some builds. Do you have the same on updated version?

Highlighted

Yes, updated version has the same issue. It seems to be related to the a couple rows are merged across the column's. If i was to unmerge the rows then I can select columns just fine. But why can I do it on every other computer in my office just fine without having to unmerge the rows? @Sergei Baklan 

Highlighted

@Reese0411 

Have no idea - same build, same file, it shall be the same behavior.

 

In general it's better to avoid merged cells at all. Could you lease check on attached file, I removed merged cells and change formatting on Center Across Selection instead.