How do I copy Excel page setup from one worksheet to others?

S

Stephen

Please ask the question in the body of the post, not the subject line!

Click the tab of the worksheet whose page setup you want. Then hold down
CTRL whilst clicking the tabs of the others. Then go itno Page Setup and
click OK.

Don't forget to click on a single tab afterwards, otherwise any changes you
make will be applied to ALL selected worksheets!
 

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

How do you format multiple worksheets in 2007 Excel? 0
How do I set up worksheet to keep tabs from being deleted? 1
How do I copy ALL formating and setup? 5
Copy "Page Setup" for multiple worksheets of identical size. 1
How do I make a single header/footer common across all worksheets? 2
How can I limit a worksheet to one page? 3
How do I get the Page Setup to apply to all the worksheets? 1
How do increase printed text size in excel and keep on 1 page? 2

Top