Forum Discussion

varoppe's avatar
varoppe
Copper Contributor
Oct 07, 2020

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

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 t...
excel
varoppe's avatar
varoppe
Copper Contributor
Oct 09, 2020

HansVogelaar 

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

 

 

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 09, 2020

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 

  • varoppe's avatar
    varoppe
    Copper Contributor
    Oct 09, 2020
    Yes. The last trick make the job.
    Thanks very much.
    How to suggest Microsoft to add the clone option to the special paste?
    Thanks

Resources