How do I store frequently used text in Excel for auto-complete?
 

Hi,
How do I store frequently used text in Excel for auto-complete?

How do I store frequently used text in Excel for auto-complete?
 

Autocomplete uses the cells directly above the cell.

Here are a couple of links:

XL97: AutoComplete Fails After 102 Rows Past Last Occurrence
http://support.microsoft.com/default.aspx?id=177423

XL2000: AutoComplete Works Differently After 102 Rows Past Last Occurrence
http://support.microsoft.com/default.aspx?id=212069

KeithyBX wrote:

Hi,
How do I store frequently used text in Excel for auto-complete?

--

Dave Peterson

How do I store frequently used text in Excel for auto-complete?
 

Care to be a little more specific?

You can type it in a cell and then copy/paste it to your desired location,
but I don't think that's what you're after...
--
-SA


"KeithyBX" wrote:

Hi,
How do I store frequently used text in Excel for auto-complete?

How do I store frequently used text in Excel for auto-complete?
 

Ooops... just re-read your post and it clicked... my bad :)
I'm not sure you can add words to the auto-complete. I only know how to add
them to the auto-correct. Good luck!
--
-SA


"KeithyBX" wrote:

Hi,
How do I store frequently used text in Excel for auto-complete?

How do I store frequently used text in Excel for auto-complete
 

Hi SA:

You can use AutoCorrect instead..For example, enter qu should be replaced by
question and its just as good autocomplete.
--
Gary''s Student - gsnu200795


"StumpedAgain" wrote:

Ooops... just re-read your post and it clicked... my bad :)
I'm not sure you can add words to the auto-complete. I only know how to add
them to the auto-correct. Good luck!
--
-SA


"KeithyBX" wrote:

Hi,
How do I store frequently used text in Excel for auto-complete?