| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Apply Page Setup to other tabs
Is there a way to copy/apply the Page Setup from one tab page
to another in Excel 2000? I find it annoying that I have to set the margins, page orientation, etc. for each tab page manually. TIA |
|
#2
|
|||
|
|||
|
Click on the "master" sheet.
ctrl-click on the others. Then try your file|page setup. Lots of stuff will be "copied" over to each sheet in the group. bruce wrote: Is there a way to copy/apply the Page Setup from one tab page to another in Excel 2000? I find it annoying that I have to set the margins, page orientation, etc. for each tab page manually. TIA -- Dave Peterson |
|
#3
|
|||
|
|||
|
Wow! Amazing!
Thanks Dave!!! Dave Peterson wrote: Click on the "master" sheet. ctrl-click on the others. Then try your file|page setup. Lots of stuff will be "copied" over to each sheet in the group. bruce wrote: Is there a way to copy/apply the Page Setup from one tab page to another in Excel 2000? I find it annoying that I have to set the margins, page orientation, etc. for each tab page manually. |
|
#4
|
|||
|
|||
|
hope you know to ungroup the sheets when done; otherwise,
anything else you do will also be done to the other sheets while grouped. To ungroup right click on a sheet tab, ungroup sheets. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to apply "page setup" defaults to an existing work. | Excel Discussion (Misc queries) | |||
| Page Numbering between tabs | Excel Discussion (Misc queries) | |||
| adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
| can you set the "Page Setup" margins etc. differently for each pag | Excel Worksheet Functions | |||
| How do I copy page setup from one worksheet & paste into new shee. | Excel Discussion (Misc queries) | |||
Linear Mode
