Printing

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Does 2007 allow all the page setup settings to be copied from one worksheet
to another worksheet?
 
Sure (as does other versions). Put both (all) the sheets in group mode by
activating the sheet with the page setups to copy, then ctrl/clicking the
2nd sheet (if ALL sheets, right-click the tab, select "Select All Sheets").
Now use the dialog launcher on the Page Layout Tab to get the Page Setup
dialog and simply click OK. All sheets will now have the same page setup
settings. Right-click any tab and select "Ungroup Sheets" to get out of
group mode.
HTH
Bob Umlas
Excel MVP
 
Note

Print Range and Rows to repeat at top cannot be duplicated on grouped
sheets.


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 Copy cells from one worksheet to another workseet - increment row & do again 0
Print on only one page 5
Print a worksheet to a page 4
Blank Sheet with Gridlines 11
Number of pages in worksheet doesn't match Print Preview pages 2
Page Setup 1
printing multiple worksheets in a workbook 1
Problem printing all worksheets in colour 1

Back
Top