how do you adjust scaling for multiple tabs all at once

Z

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
 
F

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
 
B

Bob I

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

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
 
G

Gord Dibben

Forgot to mention........

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


Gord
 
Top