Page Settings

  • Thread starter Thread starter Jane
  • Start date Start date
J

Jane

Is there any way to copy page settings ie. Margins,
landscape, headers from one sheet to the other without
having to go in and individually change settings? I am
using Excel 2003. Thanks!
 
Hi
if your 'master' sheet is the first sheet try the following:
- select yiur 'master' sheet and the other sheets by grouping them
(hold down the CTRL key while selecting them)
- goto 'File - Pagesetuip' and simply click 'OK'

Note: This copies ALL page settings
 
Well....most page settings.

Rows and Columns to repeat and print range are not copied.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

How can I copy page set up options from one sheet to another 1
save page setup settings to transfer from 1 worksheet to another 5
Printing in 2007 excel 1
How can I expand print area to whole page? 8
Page Setup - not keeping settings 1
Printing on legal paper in landscape setting 2
In excel, I can't get my right margin to zero, It goes to (.51) 1
Printing edge to edge and automatically generating a new page query 3

Back
Top