Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Copy something to more than one sheet at once
Thanks! Didn't know it was so easy and trivial! Thanks very much!
Marko |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy from one sheet and paste into other sheets | Excel Discussion (Misc queries) | |||
Copy Sheet and move to end | Excel Discussion (Misc queries) | |||
copy formula referencing sheet name to another sheet | Excel Worksheet Functions | |||
reminder notifications in a column | Excel Discussion (Misc queries) | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) |