how do you adjust scaling for multiple tabs all at once

[Zeke16]

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]

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

 

[Bob I]

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

 

[FSt1]

hi.
this shouldn't be necessary.

Regards
FSt1

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

 

[Bob I]

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

 

[Gord Dibben]

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

 

[Gord Dibben]

Forgot to mention........

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


Gord