Workbook Printing Page Format

  • Thread starter Thread starter Jim
  • Start date Start date
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)?
 
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
 
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)





.
 
Back
Top