Obviously you have had an answer to your post, but I was wondering if the
following way would be anymore appropriate?!?!?!

If you were to create a macro, (if unsure how to do this, ask and I'll send
instructions) to add the "SampleTextSampleText" into the current cell.

then assign a ctrl + ????? to it, (? being replaced by a single character a
through z)

You could use this instead.

It may be better than creating an auto correct function, because if you ever
wanted to enter the information "am" to a workbook, it might correct it to
American.... without you wanting it to.

If you were to create a macro for each, very speedy and easy, you could tap
in Ctrl + D (just an example) and it would enter the word.

This would certainly get anoying if the autocorrect features (which I think
they do) apply to all office programs. So the changes would be made to
microsoft word etc.

Hope I've been a help

Wb if I've confused you, I've got a habbit of doing that.

Dan



--
iPod's ROCK!


"LynnA" wrote:

I'm using excel, 2000. I type large lists over and over, and I don't know if
this is possible, but like in AutoCad, you can define your own shortcuts.
Like instead of typing the command "trim", their is a special place you can
define your own, so I only have to type "tr" and it acts as if I've typed the
whole word.

I want to do the same thing in excel. I type mortgage records, and get paid
for how fast I type. Instead of entering in "Americas Wholesale Lender", I
want to just put in "am", and have "Americas Wholesale Lender" pop up in the
cell I am on. Or if it has to be a shortcut like Ctrl + am, I don't care.
Their are quite a few different names that start with "American" so I don't
want to have to keep typing the whole first name till the auto find, finally
kicks in on the 10th or 11th keystroke each time.
Some kind of short cut or hot key would same me so much time. I havent
found anything other than navigation hot keys in the help.

Please help, thanks!