Page Settings

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!
 
F

Frank Kabel

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
 
G

Gord Dibben

Well....most page settings.

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

Gord Dibben Excel MVP
 
Top