How get the same custom footer on all sheets of workbk w/o copy/pa
How do I get the same custom footer on all sheets of the workbk w/o
copy/pasting? Could I set up a custon footer that could always display on the drop down list? |
How get the same custom footer on all sheets of workbk w/o copy/pa
Laurie
Select first sheet. Right-click on tab and "select all sheets". Set up your custom footer on the active worksheet and this set up will be transferred to all worksheets. DO NOT FORGET to ungroup sheets when done. What is done to activesheet will be done to all sheets in the group. Gord Dibben MS Excel MVP On Wed, 12 Apr 2006 09:21:02 -0700, Laurie wrote: How do I get the same custom footer on all sheets of the workbk w/o copy/pasting? Could I set up a custon footer that could always display on the drop down list? |
All times are GMT +1. The time now is 01:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com