Forum Discussion
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...
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.
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
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
