ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I set default footer setting on excel spreadsheets? (https://www.excelbanter.com/excel-worksheet-functions/103019-how-do-i-set-default-footer-setting-excel-spreadsheets.html)

Madison1216

How do I set default footer setting on excel spreadsheets?
 
I have an Excel spreadsheet with 10+ tabs (separate sheets) that all need to
have the same footer format. How do I either cut & paste (I haven't been
able to do this) or set it as a default in the drop down menu? I need the
same thing in the left, center, and right sections of the footer with the tab
name being the only difference.

David Biddulph

How do I set default footer setting on excel spreadsheets?
 
"Madison1216" wrote in message
...
I have an Excel spreadsheet with 10+ tabs (separate sheets) that all need
to
have the same footer format. How do I either cut & paste (I haven't been
able to do this) or set it as a default in the drop down menu? I need the
same thing in the left, center, and right sections of the footer with the
tab
name being the only difference.


Select all the sheets, then set up the footer.
--
David Biddulph




All times are GMT +1. The time now is 05:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com