If this is possible, you're much more likely to learn about it in an Excel
NG than here; this NG is for Word.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Foppa" wrote in message
...
I'm sorry I wasn't clear, I was referring to the "drop down list" on the
Header/Footer tab under Page Setup in Excel. I was wondering if there was
a
way to save a custom header/footer in this drop down list. Thanks for your
help.

"Jay Freedman" wrote:

What "same thing"? If you mean a dropdown list of AutoText entries, then
no -- Excel doesn't have AutoText.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org

Foppa wrote:
Can you do the same thing in Excel? I got it to work in Word, but not
in Excel. Thanks.

"Jay Freedman" wrote:

On Wed, 20 Jul 2005 02:50:02 -0700, "jimbo"
wrote:

I am trying to insert a new item in the pull down list in the
'insert auto text' under headers and footers and i can not figure
out how to do this.

The items in that list are the autotext entries that are formatted
with Header style or Footer style. Place your new item in a blank
document, format it with Header style, select it, and press Alt+F3.
Then you can discard the blank document, and the autotext will be
stored in the Normal.dot template (which you need to save -- hold
Shift while you click File, then select Save All).

See http://www.word.mvps.org/FAQs/Custom...n/AutoText.htm for more
info.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org