Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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???? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
Use the same name on multiple sheets in same workbook | Excel Discussion (Misc queries) | |||
In Excel, how do I print the workbook sheets to 2sided paper? | Excel Discussion (Misc queries) | |||
How do I copy formatting from 1 sheet to next in same workbook? | Excel Worksheet Functions | |||
There is no way to view multiple sheets from one workbook | Excel Discussion (Misc queries) |