Cannot select an individual column when cells are merge & center

%3CLINGO-SUB%20id%3D%22lingo-sub-1289004%22%20slang%3D%22en-US%22%3ECannot%20select%20an%20individual%20column%20when%20cells%20are%20merge%20%26amp%3B%20center%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1289004%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20running%20Office%20365%20on%20a%20Windows%2010%20machine.%26nbsp%3B%20I%20recently%20moved%20over%20from%20Macbook%2C%20but%20this%20does%20not%20appear%20to%20be%20a%20MAC%20vs%20Windows%20issue%20since%20a%20coworker%20has%20a%20different%20experience%20with%20what%20I'm%20doing.%26nbsp%3B%20There%20must%20be%20some%20option%20selected%20in%20my%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20issue%20I'm%20having%20is%20when%20a%20group%20of%20cells%20are%20merged%2C%20let's%20say%20A1%20through%20C1%2C%20if%20I%20want%20to%20select%20column%20A%20for%20deletion%20or%20editing%2C%20excel%20will%20not%20let%20me.%26nbsp%3B%20It%20will%20automatically%20highlight%20columns%20A%20-%20C.%26nbsp%3B%20If%20I%20double-click%20I%20can%20select%20a%20single%20column%2C%20but%20as%20soon%20as%20I%20right-click%20to%20delete%20or%20make%20another%20edit%2C%20it%20will%20select%20columns%20A%20through%20C.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1289004%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
Highlighted
Occasional Visitor

I am running Office 365 on a Windows 10 machine.  I recently moved over from Macbook, but this does not appear to be a MAC vs Windows issue since a coworker has a different experience with what I'm doing.  There must be some option selected in my excel.

 

The issue I'm having is when a group of cells are merged, let's say A1 through C1, if I want to select column A for deletion or editing, excel will not let me.  It will automatically highlight columns A - C.  If I double-click I can select a single column, but as soon as I right-click to delete or make another edit, it will select columns A through C.

 

Any ideas?

0 Replies