View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default How do I copy the page set up from one worksheet to another?

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

"Deb Raskob" wrote:

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