I use excel in work but type the same text constantly therefore would like to
insert the text so that I can use it over and over again without having to
type it all out. Autotext works in word by just typing the first couple of
letters of the name of text and the whole paragraph appears so I wonder if
there is a way to use this in Excel 2003. I also work from home sometimes
where I use excel 2007 so i would like to know if it would also work in Excel
2007

If you have a list of data, when you type a new value, Excel will initiate
auto text on it's own.

One thing you CAN do is use Autocorrect (ToolsAutoCorrect) to make a set of
keystrokes mean something else.

Just know that whatever you enter will apply to all Excel workbooks you
subsequently use.

So, if you do go this route, make your autocorrect keystrokes something very
unique.

"jimmys3rd" wrote:

I use excel in work but type the same text constantly therefore would like to
insert the text so that I can use it over and over again without having to
type it all out. Autotext works in word by just typing the first couple of
letters of the name of text and the whole paragraph appears so I wonder if
there is a way to use this in Excel 2003. I also work from home sometimes
where I use excel 2007 so i would like to know if it would also work in Excel
2007

You could try autocorrect.
Tools|autocorrect options|autocorrect tab
(in xl2003 menus)

Use a unique string to represent the stuff you want ($$j means Jimmy).

A benefit is that this autocorrect list is shared with all the programs in the
office suite (MSWord, excel, powerpoint...)


jimmys3rd wrote:

I use excel in work but type the same text constantly therefore would like to
insert the text so that I can use it over and over again without having to
type it all out. Autotext works in word by just typing the first couple of
letters of the name of text and the whole paragraph appears so I wonder if
there is a way to use this in Excel 2003. I also work from home sometimes
where I use excel 2007 so i would like to know if it would also work in Excel
2007

--

Dave Peterson

There is no "Autotext" in Excel 2007. You could press "AutoCorrect" into
service, simply make the additions in AutoCorrect Options.

jimmys3rd wrote:

I use excel in work but type the same text constantly therefore would like to
insert the text so that I can use it over and over again without having to
type it all out. Autotext works in word by just typing the first couple of
letters of the name of text and the whole paragraph appears so I wonder if
there is a way to use this in Excel 2003. I also work from home sometimes
where I use excel 2007 so i would like to know if it would also work in Excel
2007

If the pre-entered text is in a contiguous range in same column above or
below the text to enter, "Autocomplete" will work.


Gord Dibben MS Excel MVP

On Fri, 2 Oct 2009 07:23:02 -0700, jimmys3rd
wrote:

I use excel in work but type the same text constantly therefore would like to
insert the text so that I can use it over and over again without having to
type it all out. Autotext works in word by just typing the first couple of
letters of the name of text and the whole paragraph appears so I wonder if
there is a way to use this in Excel 2003. I also work from home sometimes
where I use excel 2007 so i would like to know if it would also work in Excel
2007