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

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

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.

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.