Workbook Printing Page Format

J

Jim

I wish to apply the same page format (2 sided printing,
landscape, margins, %reduction or fit to page, etc) to
all worksheets in a workbook. Is there an easy method or
do I need to go to Page Setup in each worksheet (if so,
can I copy the Page Setup from another sheet)?
 
O

Orlando Magalhães Filho

Hi Jim,

Do this:
- Right click on Tab sheet
- Click on Select All Sheets command
- Go File menu > Page Setup command and so on


HTH
 
J

Jim

Thanks!!!
-----Original Message-----
Hi Jim,

Do this:
- Right click on Tab sheet
- Click on Select All Sheets command
- Go File menu > Page Setup command and so on


HTH

---
Orlando Magalhães Filho

(So that you get best and rapid solution and all may benefit from the
discussion, please reply within the newsgroup, not in email)





.
Click to expand...
 

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 I copy the page set up from one worksheet to another? 2
Excel Workbook printing 4
Picture Links printing problem - Help! 1
formatting sheets in a workbook 4
Excel Fit to page print options in Excel 1
Setting up page template 1
Worksheet page numbering 3
Page breaks 4

Top