Hi,

I have created an Excel 2000 workbook. Inside this i have 52 worksheets for
each week in a year. I need to change something in all of the work sheets and
add a new colum. Is there a way to do this in just 1 worksheet and then save
it into all the others without changing each individual sheet?

Thanks In Advance,

Grant

Select one sheet then right-click on the sheet tab and "Select all sheets"

This groups the sheets.

What you do to the active sheet will be done to all.

DO NOT forget to ungroup the sheets when you are done.


Gord Dibben MS Excel MVP

On Tue, 22 Apr 2008 19:42:00 -0700, GeeWhizz
wrote:

Hi,

I have created an Excel 2000 workbook. Inside this i have 52 worksheets for
each week in a year. I need to change something in all of the work sheets and
add a new colum. Is there a way to do this in just 1 worksheet and then save
it into all the others without changing each individual sheet?

Thanks In Advance,

Grant

Thankyou Very much, it worked a treat

Grant

"Gord Dibben" wrote:

Select one sheet then right-click on the sheet tab and "Select all sheets"

This groups the sheets.

What you do to the active sheet will be done to all.

DO NOT forget to ungroup the sheets when you are done.


Gord Dibben MS Excel MVP

On Tue, 22 Apr 2008 19:42:00 -0700, GeeWhizz
wrote:

Hi,

I have created an Excel 2000 workbook. Inside this i have 52 worksheets for
each week in a year. I need to change something in all of the work sheets and
add a new colum. Is there a way to do this in just 1 worksheet and then save
it into all the others without changing each individual sheet?

Thanks In Advance,

Grant