Copy something to more than one sheet at once

  • Thread starter Thread starter marko
  • Start date Start date
M

marko

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
 
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 want>Copy>got to
cell A1 and Paste.

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

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

Marko
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Copy a sheet more than one time 4
Newbie for starters with excel, I am needing to transfer info fromsheet2 to the universe sheet. 1
Arrays containing variable sheets 2
Autocopy the first cell with more than 30 characters to a different sheet? 1
Lookup more then one sheet as reference 1
Macro to copy portion of each sheet and paste into the first sheet asa picture 1
VB Script for Copy Sheet 14

Back
Top