View Single Post
  #2   Report Post  
Gary Rowe
 
Posts: n/a
Default

Select the sheet with the page setup you want then using the shift or control
key select the sheet(s) you want with the same page setup, then select File,
Page Setup, then OK and all the worksheets will inherit the page setup of the
first sheet selected.
Gary

"Fanny" wrote:

I want to copy my page setups from one worksheet to another within a
workbook. When I copy and paste, all the worksheet stuff is there but not
the page setups and I have to re-do them all over again.