Insert copied cells won't work

%3CLINGO-SUB%20id%3D%22lingo-sub-1414910%22%20slang%3D%22en-US%22%3EInsert%20copied%20cells%20won't%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1414910%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20I%20check%20with%20any%20of%20u%20that%20one%20issue%20I%20am%20facing...I%20have%20an%20excel%20file%20with%20few%20tabs%2C%20there%20is%20one%20tab%20that%20I%20can%20%22copy%22%20the%20whole%20row%20then%20%22insert%20copy%20cells%22%20at%20another%20whole%20row%20which%20also%20captures%20all%20formula%20within%20that%20particular%20row%20perfectly.%20However%20for%20another%20tab%2C%20after%20I%20%22copy%22%2C%20when%20right%20click%20at%20another%20row%2C%20%22insert%20copy%20cells%22%20option%20is%20not%20shown%20at%20all.%20This%20is%20also%20the%20tab%20that%20I%20have%26nbsp%3Bcopied%20some%20macro%20formula%20from%20youtube%20(since%20I%20don't%20know%20about%20macro)%20so%20I%20can%20sum%20by%20color.%20The%20weird%20thing%20is%20even%20after%20I%20take%20out%20macro%2C%20the%20issue%20still%20persists.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1414910%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi,

 

Can I check with any of u that one issue I am facing...I have an excel file with few tabs, there is one tab that I can "copy" the whole row then "insert copy cells" at another whole row which also captures all formula within that particular row perfectly. However for another tab, after I "copy", when right click at another row, "insert copy cells" option is not shown at all. This is also the tab that I have copied some macro formula from youtube (since I don't know about macro) so I can sum by color. The weird thing is even after I take out macro, the issue still persists.

 

Can anyone help?

1 Reply
Highlighted
Hi Sean

Difficult to know without seeing the file. Any chance you could delete any data and post a copy with a couple of fake numbers in?