Changes to Mulitple Worksheets

[Mac Landers]

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?

[Mac Landers]

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?

[AmyJolFin]

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?

[Mac Landers]

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?