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????
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.
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
ps. And if they are all the sheets in the workbook, you can rightclick on any
worksheet tab and choose "select all sheets"
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks