Excel 2007 : Copy & Paste formulas to multiple Worksheets

**Karamazov** · 08-10-2010, 07:28 AM

I am using Excel 2007. I need to copy formulas from one worksheet to a large number of other worksheets. How can I do this without having to go back to the original worksheet each time and doing copy/paste. I tried using the clipboard but when I paste it copies values not formulas.

Thanks

Karamazov

**Karamazov** · 08-11-2010, 05:20 AM

Apologies for that, I have now changed the title

Regards

Karamazov

**arthurbr** · 08-11-2010, 05:29 AM

You can use Paste Special - Formulas or, if the formula go into the same cell, select the first sheet tab, and while pressing the shift key, select the last sheet where the formula is needed.
This will group the sheets,and when entering the formula in the first it is copied in the others.
Don't forget to ungroup the sheets when you're done

**Karamazov** · 08-11-2010, 06:41 AM

I have used Paste Special-Formulas but I still have to go back to the original worksheet each time to Copy.The formulas go into different cells in each worksheet so Im not sure if grouping would work.

Thanks

Karamazov