Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Changes to Mulitple Worksheets
If I have a workbook with multiple worksheets that all have the same format
just didn't products and numbers, is there a way to apply a change to one worksheet and it will change in all of the other worksheets? Is there one easy step instead of manually updating each worksheet? |
#2
|
|||
|
|||
Figured it out.
"Mac Landers" wrote: If I have a workbook with multiple worksheets that all have the same format just different products and numbers, is there a way to apply a change to one worksheet and it will change in all of the other worksheets? Is there one easy step instead of manually updating each worksheet? |
#3
|
|||
|
|||
I have the same question. How did you figure it out?
Thanks, Amy "Mac Landers" wrote: Figured it out. "Mac Landers" wrote: If I have a workbook with multiple worksheets that all have the same format just different products and numbers, is there a way to apply a change to one worksheet and it will change in all of the other worksheets? Is there one easy step instead of manually updating each worksheet? |
#4
|
|||
|
|||
If you highlight all of the worksheets (click on the 1st one and then hit
control and click on the other worksheets you wish to change) it is called "Grouping." Once you make a change to the 1st spreadsheet it changes the rest. Right click on any of the tabs to "Ungroup Sheets" after you are done. "AmyJolFin" wrote: I have the same question. How did you figure it out? Thanks, Amy "Mac Landers" wrote: Figured it out. "Mac Landers" wrote: If I have a workbook with multiple worksheets that all have the same format just different products and numbers, is there a way to apply a change to one worksheet and it will change in all of the other worksheets? Is there one easy step instead of manually updating each worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
Protect/unprotect all worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) |