software

I know I have posted this before and got no answers. Anyone know where else I
can go for an answer?

I have a spreadsheet with 4660 rows and AutoComplete does not pick up
anything before row 4007.

Why is this? Is there somthing in particular it won't pick up? All of the
entries are text but some are individual letters - does this make a
difference?

ThanksHi Phippsy,

I don't know if this will be helpful, but in my experience with my
spreadsheets I have found that the autocomplete will not work when there is
an empty row between the cell I am filling out, and the last instance of the
identical word. For instance, If I have the word quot;Reservequot; in A1, if I type
quot;rquot; in A2 it will auto complete. If I type quot;rquot; in say, A4 leaving A3 empty it
will not autocomplete. It will auto complete if there is any word in the
empty cell, even a space.

Squeaky

quot;Phippsyquot; wrote:

gt; I know I have posted this before and got no answers. Anyone know where else I
gt; can go for an answer?
gt;
gt; I have a spreadsheet with 4660 rows and AutoComplete does not pick up
gt; anything before row 4007.
gt;
gt; Why is this? Is there somthing in particular it won't pick up? All of the
gt; entries are text but some are individual letters - does this make a
gt; difference?
gt;
gt; Thanks
gt;

Thanks but that is not the case as I have checked that. Any more offers?!

quot;Squeakyquot; wrote:

gt; Hi Phippsy,
gt;
gt; I don't know if this will be helpful, but in my experience with my
gt; spreadsheets I have found that the autocomplete will not work when there is
gt; an empty row between the cell I am filling out, and the last instance of the
gt; identical word. For instance, If I have the word quot;Reservequot; in A1, if I type
gt; quot;rquot; in A2 it will auto complete. If I type quot;rquot; in say, A4 leaving A3 empty it
gt; will not autocomplete. It will auto complete if there is any word in the
gt; empty cell, even a space.
gt;
gt; Squeaky
gt;
gt; quot;Phippsyquot; wrote:
gt;
gt; gt; I know I have posted this before and got no answers. Anyone know where else I
gt; gt; can go for an answer?
gt; gt;
gt; gt; I have a spreadsheet with 4660 rows and AutoComplete does not pick up
gt; gt; anything before row 4007.
gt; gt;
gt; gt; Why is this? Is there somthing in particular it won't pick up? All of the
gt; gt; entries are text but some are individual letters - does this make a
gt; gt; difference?
gt; gt;
gt; gt; Thanks
gt; gt;