Format Worksheets in a Workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I set a global print format for many worksheets within workbook?
 
Most print setup functions will be available for grouped sheets.

Right-click on a sheet tab and "select all sheets"

Do your print setup on the active sheet and will be done to all sheets.

NOTE.............you cannot set print range or rows to repeat at top using this
method.

Those must be set using code.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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 Highlighting duplicates 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
New Worksheet Default Number Setting 2
Excel Count If Formula Question 1
Using VBA to copy data into another worksheet ??? 2
Excel - Problem w/ printing more than one worksheet with same sett 0
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Copy of Print Setup 2

Back
Top