how do you adjust scaling for multiple tabs all at once

I have about 20 tabs that I would like to adjust the margins and the fit on
one page feature all at the same time. Wondering if it can be done. Working
with Excel 2000

FSt1
Fri May 09 08:16:01 CDT 2008

hi
not sure if you can do this. this is one problem with many sheets in a
workbook
but as an alternative, try this....
right click the sheet navigator in the lower left of the screen. you should
get a pop up listing all of your sheets. click one to go to it.

Regards
FSt1

"Zeke16" wrote:

> I have about 20 tabs that I would like to adjust the margins and the fit on
> one page feature all at the same time. Wondering if it can be done. Working
> with Excel 2000

Bob
Fri May 09 08:33:42 CDT 2008

R-click on one of the tabs and pick "Select All Sheets" to "group" them
first.

Zeke16 wrote:

> I have about 20 tabs that I would like to adjust the margins and the fit on
> one page feature all at the same time. Wondering if it can be done. Working
> with Excel 2000

FSt1
Fri May 09 09:48:01 CDT 2008

hi.
this shouldn't be necessary.

Regards
FSt1

"Bob I" wrote:

> R-click on one of the tabs and pick "Select All Sheets" to "group" them
> first.
>
> Zeke16 wrote:
>
> > I have about 20 tabs that I would like to adjust the margins and the fit on
> > one page feature all at the same time. Wondering if it can be done. Working
> > with Excel 2000
>
>

Bob
Fri May 09 10:26:55 CDT 2008

In Excel 2003 each tab (sheet) is individually set. Is this not the same
for 2000?

FSt1 wrote:

> hi.
> this shouldn't be necessary.
>
> Regards
> FSt1
>
> "Bob I" wrote:
>
>
>>R-click on one of the tabs and pick "Select All Sheets" to "group" them
>>first.
>>
>>Zeke16 wrote:
>>
>>
>>>I have about 20 tabs that I would like to adjust the margins and the fit on
>>>one page feature all at the same time. Wondering if it can be done. Working
>>>with Excel 2000
>>
>>

Gord
Fri May 09 12:08:45 CDT 2008

Right-click on one sheet tab and "Select all sheets".

Do the File>Page Setup on the active sheet and will be done to all.


Gord Dibben MS Excel MVP

On Fri, 9 May 2008 06:03:02 -0700, Zeke16 <Zeke16@discussions.microsoft.com>
wrote:

>I have about 20 tabs that I would like to adjust the margins and the fit on
>one page feature all at the same time. Wondering if it can be done. Working
>with Excel 2000

Gord
Fri May 09 12:13:56 CDT 2008

Forgot to mention........

Setting Print Range and Rows to Repeat at top cannot be done on grouped sheets.


Gord

On Fri, 09 May 2008 10:08:45 -0700, Gord Dibben <gorddibbATshawDOTca> wrote:

>Right-click on one sheet tab and "Select all sheets".
>
>Do the File>Page Setup on the active sheet and will be done to all.
>
>
>Gord Dibben MS Excel MVP
>
>On Fri, 9 May 2008 06:03:02 -0700, Zeke16 <Zeke16@discussions.microsoft.com>
>wrote:
>
>>I have about 20 tabs that I would like to adjust the margins and the fit on
>>one page feature all at the same time. Wondering if it can be done. Working
>>with Excel 2000