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

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
 
E

Eduardo

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
 
J

Jacob Skaria

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
 

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
Copy worksheet from one workbook to a master workbook 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Copy protection from one worksheet to another 2
copy an exact formula without changing cell reference 1
How do I sum totals from mulitple worksheets 1
Linking value of cell on one worksheet to a column on another work 1
Excel 2007 Move or Copy worksheet 2

Top