View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Copy custom footer across multiple sheets

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

On Aug 5, 9:05*pm, Clark wrote:
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.
--
Thanks!

Clark Falcione Sr