| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scaling Multiple Graphs At the Same Time | Charts and Charting in Excel | |||
| Create multiple sheet tabs from multiple cells. | Excel Worksheet Functions | |||
| How do I set up multiple tabs within a column? | Excel Worksheet Functions | |||
| How do I use VLOOKUP to ref multiple workbooks with multiple tabs? | Excel Discussion (Misc queries) | |||
| Vlookup across multiple tabs | Excel Worksheet Functions | |||
Hybrid Mode
