How to clone a cell (or group of cells)?

%3CLINGO-SUB%20id%3D%22lingo-sub-1755216%22%20slang%3D%22en-US%22%3EHow%20to%20clone%20a%20cell%20(or%20group%20of%20cells)%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1755216%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20you%20clone%20a%20cell%20in%20a%20different%20position%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3A%3C%2FP%3E%3CP%3EI%20have%20in%20Cell%20C1%20the%20following%20content%3A%20%22%3DA1%2BB1%22%3C%2FP%3E%3CP%3EWhere%20in%20A1%3D2%20and%20B1%3D3%20so%20Cell%20C1%3D5%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20clone%20Cell%20C1%20to%20C2%20so%20that%20in%20both%20cells%2C%20C1%20and%20C2%2C%20there%20is%20the%20same%20formula%3A%20%22%3DA1%2BB1%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20perform%20such%20cloning%3F%3C%2FP%3E%3CP%3EI%20was%20looking%20into%20the%20Paste%20Special%20options%20but%20didn't%20find%20anything%20that%20would%20do%20that.%3C%2FP%3E%3CP%3EDo%20you%20have%20any%20suggestion%20on%20how%20to%20do%20that%2C%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1755216%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1755394%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20clone%20a%20cell%20(or%20group%20of%20cells)%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1755394%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F823914%22%20target%3D%22_blank%22%3E%40varoppe%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EChange%20the%20formula%20in%20C1%20to%20%3D%24A%241%2B%24B%241%3C%2FP%3E%0A%3CP%3EYou%20can%20now%20copy%2Fpaste%20C1%20to%20C2%20(or%20wherever%20you%20want)%20and%20the%20formula%20will%20remain%20the%20same.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1764675%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20clone%20a%20cell%20(or%20group%20of%20cells)%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1764675%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20reply.%3C%2FP%3E%3CP%3EI%20know%20that%20the%20%24%20sign%20allow%20to%20stick%20to%20the%20specific%20cell.%3C%2FP%3E%3CP%3EYet%2C%20I%20still%20need%20to%20clone%20my%20cell(s).%3C%2FP%3E%3CP%3EIndeed%20the%20example%20was%20just%20to%20explain%20the%20question.%3C%2FP%3E%3CP%3EMy%20real%20case%20is%20that%20I%20have%20a%20very%20complex%20summary%20table%20within%20an%20excel%20tab%20and%20want%20to%20clone%203%20times%20to%20make%20minor%20modifications%20and%20then%20make%20What-if%20analysis.%3C%2FP%3E%3CP%3ERight%20now%20I%20am%20copying%20the%20table%20on%20a%20CSV%20and%20then%20import%20it%20back%20again.%20Is%20there%20a%20way%20to%20do%20as%20a%20special%20paste%2C%20please%3F%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EGiuseppe%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

How can you clone a cell in a different position?

 

For example:

I have in Cell C1 the following content: "=A1+B1"

Where in A1=2 and B1=3 so Cell C1=5

 

I would like to clone Cell C1 to C2 so that in both cells, C1 and C2, there is the same formula: "=A1+B1"

 

Is there a way to perform such cloning?

I was looking into the Paste Special options but didn't find anything that would do that.

Do you have any suggestion on how to do that, please?

 

Thanks,

 

 

 

 

 

5 Replies

@varoppe 

Change the formula in C1 to =$A$1+$B$1

You can now copy/paste C1 to C2 (or wherever you want) and the formula will remain the same.

@Hans Vogelaar 

Thanks for your reply.

I know that the $ sign allow to stick to the specific cell.

Yet, I still need to clone my cell(s).

Indeed the example was just to explain the question.

My real case is that I have a very complex summary table within an excel tab and want to clone 3 times to make minor modifications and then make What-if analysis.

Right now I am copying the table on a CSV and then import it back again. Is there a way to do as a special paste, please?

Thanks,

Giuseppe

 

 

 

@varoppe 

To my knowledge there is no one-click action to clone the formula. Tricks are here Copy a Formula  , perhaps your case at very bottom of above 

Yes. The last trick make the job.
Thanks very much.
How to suggest Microsoft to add the clone option to the special paste?
Thanks

@varoppe , you are welcome.

 

Practically the only way is to submit that on https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application (if it wasn't already submitted). Microsoft monitors this source and adjust its plans based on feedback on it. More votes - more chances it'll be implemented.