Apply Page Setup to other tabs

B

bruce

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
 
D

Dave Peterson

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.
 
B

bruce

Wow! Amazing!
Thanks Dave!!!

Dave said:
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.
Click to expand...
 
D

David McRitchie

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
Section and Page numbering 0
Changing margins on 2nd page of letterhead template 4
MS Word Page Layout/Break/Margin Issues, help 0
Converting excel to PDF, single page converts to multiple HELP! 1
Word 2016 - Difficulties Learning Style Creation/Application 0
Indenting every other paragraph in Word at the same time? 0
Page numbering with Merged Document and IF statements 1

Top