How do I copy print formatting to multiple sheets in a workbook?
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.
BFB@keystone wrote:
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????
--
Dave Peterson
|