Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoComplete Please!
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? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoComplete Please!
Hi 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 "Reserve" in A1, if I type "r" in A2 it will auto complete. If I type "r" 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 "Phippsy" wrote: 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? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoComplete Please!
Thanks but that is not the case as I have checked that. Any more offers?!
"Squeaky" wrote: Hi 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 "Reserve" in A1, if I type "r" in A2 it will auto complete. If I type "r" 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 "Phippsy" wrote: 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? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autocomplete? | Excel Discussion (Misc queries) | |||
Autocomplete numbers help pls! | Excel Discussion (Misc queries) | |||
Autocomplete function | Excel Discussion (Misc queries) | |||
Office 2003 - "autocomplete" in file | open or file | save no longer works | Excel Discussion (Misc queries) | |||
Autocomplete works with my home computer but not the office computer | Excel Discussion (Misc queries) |