SOLVED

Select a single column 'crossing' a merged cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2970694%22%20slang%3D%22en-US%22%3ESelect%20a%20single%20column%20'crossing'%20a%20merged%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2970694%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EI%20need%20to%20select%20a%20single%20column%20that%20%22crosses%22%20a%20merged%20cell%20to%20insert%20a%20new%20column%20across%20the%20merged%20cell%20(usually%20the%20merged%20cell%26nbsp%3Bwill%20extend).%3C%2FP%3E%3CP%3EThe%20action%20I%20have%20just%20described%20is%20a%20normal%20action%20for%20excel%2C%20but%20since%202%20weeks%20ago%20is%20not%20for%20me%20and%20I%20can't%20find%20a%20solution.%20For%20example%2C%20when%20I%20try%20to%20select%20the%20whole%20column%20%22B%22%20in%20the%20excel%20file%20in%20attachment%20called%20%22%3CEM%3Eexample.xlsx%3C%2FEM%3E%22%2C%20the%20columns%20from%20%22A%22%20to%20%22H%22%20are%20automatically%20selected.%3C%2FP%3E%3CP%3EAll%20the%20other%20collegues%20in%20my%20office%20can%20do%20that%20on%20the%20same%20excel%20files%20(with%20their%20computer).%3C%2FP%3E%3CP%3ESomeone%20can%20help%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EFederico%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2970694%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2970786%22%20slang%3D%22en-US%22%3ERe%3A%20Select%20a%20single%20column%20'crossing'%20a%20merged%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2970786%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1220220%22%20target%3D%22_blank%22%3E%40federico_rampa%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EIf%20you%20select%20a%20range%20of%20cells%20in%20column%20B%2C%20the%20selection%20will%20extend%20to%20columns%20A%3AH%20when%20you%20include%20B1%20in%20the%20selection.%3C%2FP%3E%0A%3CP%3EClicking%20or%20right-clicking%20on%20the%20column%20letter%20B%20should%20select%20only%20column%20B%2C%20though.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi all,

I need to select a single column that "crosses" a merged cell to insert a new column across the merged cell (usually the merged cell will extend).

The action I have just described is a normal action for excel, but since 2 weeks ago is not for me and I can't find a solution. For example, when I try to select the whole column "B" in the excel file in attachment called "example.xlsx", the columns from "A" to "H" are automatically selected.

All the other collegues in my office can do that on the same excel files (with their computer).

Someone can help me?

 

Thanks,

Federico

5 Replies

@federico_rampa

If you select a range of cells in column B, the selection will extend to columns A:H when you include B1 in the selection.

Clicking or right-clicking on the column letter B should select only column B, though.

 

Unfortunately not, if I select column B clicking on the column letter B the columns A:H are automatically selected.
I also checked if I had accidentally activated a particular function but even in the advanced options I couldn't find anything about it.
best response confirmed by federico_rampa (New Contributor)
Solution

@federico_rampa 

Similar issue was discussed here Excel selects multiple columns/rows if a cell is merged - Microsoft Community

In that case Logitech Options Add-In was the root of the problem. Try Excel in safe mode if you may reproduce an issue.

@Sergei Baklan 

You're right, I disabled the add-in and now excel works properly.

Thank you very much, have a nice day.

Federico

@federico_rampa , great to know it woks now, thank you for the feedback. Have a nice day too.