Thread: How do I store frequently used text in Excel for auto-complete?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote