copy page setup from worksheet to another within workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How do I copy the page set up from one worksheet to another? 2
Copy formulas from one workbook to another 1
How do I combine data from multiple worksheets into one master lis 3
Copying Excel formulas from one Workbook to another 3
How to paste across 20 worksheets within one workbook 3
Worksheet and workbook question 1
Relative worksheet reference for multiple worksheets in a workbook 5

Back
Top