How do I copy the page set up from one worksheet to another?

  • Thread starter Thread starter Deb Raskob
  • Start date Start date
D

Deb Raskob

I have data in multiple worksheets in one workbook. I would like the same
page setup on each sheet. Can I copy the page set up from one worksheet to
another or do I have to go into each worksheet and do page setup? I am using
both Office 2003 and Office 2007.
Thank you
 
Hi,
Highlight the worksheet you want to copy the set up from, copy, click the
first sheet you want to copy the format to, then hold the Shift key, and
clikck in the last sheet, go to cell A1, paste special formats
 
Try selecting the sheet tabs before doing the PageSetup..Right click on Sheet
tab>'Select All Sheets' OR use Ctrl key to select sheets

If this post helps click Yes
 
Back
Top