Copy custom footer across multiple sheets

[Clark]

Does anyone know how you can copy page settings across multiple pages?
Example: margins and custom footers from one page in a file to the rest of
the pages within the same file.

 

[Pete_UK]

You can group all the sheets together by right-clicking a sheet tab
and clicking on Select All Sheets (the sheet tabs will change to
white). With this setting, then whatever you do in one sheet will be
reflected in all the grouped sheets. So, you can click on File | Page
Setup and then make adjustments on the Page, Margins or Header&Footer
tabs, and all grouped sheets will pick up these settings.

Remember to Ungroup the sheets once you are finished by right-clicking
a sheet tab again.

Hope this helps.

Pete

 

[Clark]

Hey there Pete,

Thanks for responding! The way you described this is a little different
then how I used to do it in 2003 Excel. Now that we have upgraded to 2007
Excel I selected the pages like you suggested but I do not have a File l Page
Setup selection. However in my ribbon there is a section labeled Page Setup
under the Page Layout tab. In this section I went to Print Titles and it
brings up the page setup settings screen. I made my changes and hit OK and
all of the sheets were changed!

--
Thanks!

Clark

You can group all the sheets together by right-clicking a sheet tab
and clicking on Select All Sheets (the sheet tabs will change to
white). With this setting, then whatever you do in one sheet will be
reflected in all the grouped sheets. So, you can click on File | Page
Setup and then make adjustments on the Page, Margins or Header&Footer
tabs, and all grouped sheets will pick up these settings.

Remember to Ungroup the sheets once you are finished by right-clicking
a sheet tab again.

Hope this helps.

Pete

 

[Pete_UK]

Glad to hear you got it to work, Clark - thanks for feeding back.

Pete