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?
Laurie
Select first sheet.
Right-click on tab and quot;select all sheetsquot;.
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 gt;
wrote:
gt;How do I get the same custom footer on all sheets of the workbk w/o
gt;copy/pasting?
gt;Could I set up a custon footer that could always display on the drop down
gt;list?
copy/pasting?
Could I set up a custon footer that could always display on the drop down
list?
Laurie
Select first sheet.
Right-click on tab and quot;select all sheetsquot;.
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 gt;
wrote:
gt;How do I get the same custom footer on all sheets of the workbk w/o
gt;copy/pasting?
gt;Could I set up a custon footer that could always display on the drop down
gt;list?
文章標籤
全站熱搜
