copying page formatting

  • Thread starter Thread starter ben rankin
  • Start date Start date
B

ben rankin

I need to know if there is a way to copy the contents of
a worksheet including the page formatting and print
settings into another worksheet in the same workbook or
even into a different workbook. I have tried sereral
times and can get cell contents, column widths and
formulae coppied with no problem but the page formatting
and print settings all must be set individually and this
is taking my employee far too long to set the page
formatting and print settings exactly like the prior
worksheets. Any help would be appreciated.
 
Hi
one way:
- make the master sheet the first sheet
- select the 'master' sheet and the target sheet (while holding down
the sHIFT key -> grouping the sheets)
- goto 'File - Pagesetup' and hit OK
 
Back
Top