Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Laurie
 
Posts: n/a
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to automate custom footer on all tabs neal august Excel Discussion (Misc queries) 1 March 3rd 05 02:38 PM
How can I get yesterdays date in a custom footer &[DATE]-1 does . chuck Charts and Charting in Excel 1 February 17th 05 02:49 AM
How do I make the custom headers and footer repeat on every works. Chrisod Excel Worksheet Functions 3 January 24th 05 09:05 AM
How do I add my own custom footer to the standard choices? sraftcpa Setting up and Configuration of Excel 1 December 9th 04 04:36 PM
Custom footer Chrissy New Users to Excel 2 December 3rd 04 09:01 PM


All times are GMT +1. The time now is 07:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"