Home

I would like the option to insert a column when I have copied cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1194015%22%20slang%3D%22en-US%22%3EI%20would%20like%20the%20option%20to%20insert%20a%20column%20when%20I%20have%20copied%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1194015%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20I%20copy%20cells%20and%20right%20click%20a%20column%20header%20the%20normal%20insert%20command%20is%20replaced%20by%20insert%20copied%20cells.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20would%20prefer%20the%20insert%20option%20still%20appears%20in%20that%20menu%20so%20I%20can%20add%20in%20a%20blank%20column.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EMore%20often%20than%20not%20I%20want%20to%20past%20the%20copied%20cells%20is%20a%20specific%20place%20and%20the%20insert%20copied%20cells%20isn't%20what%20I%20want.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1194015%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-1194087%22%20slang%3D%22en-US%22%3ERe%3A%20I%20would%20like%20the%20option%20to%20insert%20a%20column%20when%20I%20have%20copied%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1194087%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F567886%22%20target%3D%22_blank%22%3E%40ExcelUserZ%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20not%20insert%20column%20first%2C%20then%20copy%20and%20paste%20necessary%20data%20after%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

If I copy cells and right click a column header the normal insert command is replaced by insert copied cells.


I would prefer the insert option still appears in that menu so I can add in a blank column. 

More often than not I want to past the copied cells is a specific place and the insert copied cells isn't what I want. 

1 Reply
Highlighted

Hello @ExcelUserZ,

 

Why not insert column first, then copy and paste necessary data after?

Related Conversations