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

how do you adjust scaling for multiple tabs all at once
 

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

how do you adjust scaling for multiple tabs all at once
 

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

how do you adjust scaling for multiple tabs all at once
 

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

how do you adjust scaling for multiple tabs all at once
 

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

how do you adjust scaling for multiple tabs all at once
 

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

Do the FilePage 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
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

how do you adjust scaling for multiple tabs all at once
 

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 FilePage 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
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