Copy formula in multiple worksheets

[Pezgordo]

I have a spreadsheet that contains 120 worksheets. How would I copy a formula (it starts at EY7 and ends at EY19) into each worksheet without copying and pasting it 120 times?

Thank you,

Tim

 

[gtche98]

If you have the correct beginning cell selected on each worksheet (EY7, assuming it starts in the same cell on every sheet), you can copy the formula range from the first one, then ctrl+click each tab you want to paste to, then paste.

 

[circledchicken]

Not sure if this is exactly what you wanted, but similar to the above:

1. Select the first sheet.
2. Hold 'Shift' and select the last sheet (all sheets should now be selected).
3. Enter the data/formula's in the current sheet, and they will be copied into all the other sheets (in the identical cells) as well.
4. Click as normal on another sheet tab to re-select a single sheet.

 

[Pezgordo]

Thank you. Both solutions worked great.