Is there a way to format page orientation, margins for all worksh.

G

Guest

Is there a way to format margins and page orientation for all worksheets in a
workbook at the same time without the hassle of doing it worksheet by
worksheet?
 
G

Gord Dibben

Deb

Right-click on first sheet tab and "select all sheets".

Do your page setup on active sheet and it will be done to all sheets.

If first sheet already has the settings you want, just do the File>Page Setup
and OK.

Settings will be transferred to other sheets.

Note: you cannot set print range and rows to repeat at top.

DO NOT FORGET to ungroup the sheets when Page Setup is complete.


Gord Dibben Excel MVP
 

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

can I change page layout in an entire existing Excel workbook? 2
Excel 2007 Page and Print Formatting 4
How to select all worksheets in a workbook 8
How do I get the Page Setup to apply to all the worksheets? 1
how do i permanently change the page setup in excel? 1
Page setup whilst in Group mode 2
Can I copy a worksheet with its page setup and print formats? 2
Ruler And Margins Problem ? 1

Top