New Contributor

# 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 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

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

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.

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

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

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

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

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

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

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

@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.