How do I copy print formatting to multiple sheets in a workbook?

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

Guest

I have a large Excel Workbook (96 worksheets) and I need to set ALL sheets to
the same print formatting (margins, page breaks, footers, etc).
Any ideas????
 
Lots of settings can be changed all at once if you group the sheets (select the
first and ctrl-click (or shift-click to select subsequent.

Then when all of the sheets are grouped, try file|page setup and see if you can
change all the settings you want.

Make sure you ungroup the sheets when you're done--almost any change you make to
one of the grouped sheets, you make to the others.

ps. You may want to try it on a few grouped sheets. If it works, then group
all 96.
 
ps. And if they are all the sheets in the workbook, you can rightclick on any
worksheet tab and choose "select all sheets"
 
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

page setup 2
Merge Multiple workbook sheets into one workbook 0
Formatting problem copying sheet 3
Excel 2007 Page and Print Formatting 4
Excel 2007 page break changes when forwarding workbooks 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Printing Sheets in a Workbook 3
Printing multiple sheets... 1

Back
Top