If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
page set-up
I have a workbook with multiple worksheets. Does anyone know how you can
copy the page formatting (headers/footers, etc) from one worksheet to another? |
#2
|
|||
|
|||
page set-up
Lots of print settings can be set if you group the worksheets first.
Select the first worksheet tab. Then ctrl-click on subsequent worksheet tabs. Then do your page setup stuff. This may change more than you want, so test the results. And after you're done, ungroup the worksheets. Rightclick on one of the selected worksheet tabs and select "ungroup sheets". Otherwise, you could be making changes to each of the grouped worksheets for things you don't want! washaz wrote: I have a workbook with multiple worksheets. Does anyone know how you can copy the page formatting (headers/footers, etc) from one worksheet to another? -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|