How do I copy print formatting to multiple sheets in a workbook?
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???? |
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 |
How do I copy print formatting to multiple sheets in a workbook?
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 |
All times are GMT +1. The time now is 11:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com