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
HansVogelaar's avatar
HansVogelaar
MVP
Oct 07, 2020

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.

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