Copy something to more than one sheet at once
 

Hi!
I have a workbook with 30 sheets and i forgot to put some formulas in
28 sheets(this is an example of my problem). Now I would like to put
the same formula(it could be text of anything else) on the same places
in those sheets(all 28 of them). How can that be done?
Thanks.

Marko

Copy something to more than one sheet at once
 

Hi Marko

Select the first of the 30 sheets, hold the shift button down and select the
30th sheet. This will group them and the word Group will appear at the top
left of the screen.
Anything you do to one sheet, whilst grouped will be reflected in all of the
grouped sheets.
Select the complete range containing all the values you wantCopygot to
cell A1 and Paste.

Click on any individual sheet to un-group them.
Regards

Roger Govier


marko wrote:
Hi!
I have a workbook with 30 sheets and i forgot to put some formulas in
28 sheets(this is an example of my problem). Now I would like to put
the same formula(it could be text of anything else) on the same places
in those sheets(all 28 of them). How can that be done?
Thanks.

Marko

Copy something to more than one sheet at once
 

Thanks! Didn't know it was so easy and trivial! Thanks very much!

Marko