MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Auto Text with info from above cell

Posted by Armand on January 24, 2002 11:13 AM

How come sometimes a cell automatically gets filled with information from cells above it and some time it does not. Is there an on/off feature? If yes, where.

Thank you

Posted by Tom Morales on January 24, 2002 11:31 AM

I can't speak for the fickleness of this feature, but if it bugs you, it can be turned off. Go to Tools/Options/Edit, and deselect the box that reads "Enable AutoComplete for Cell Values".

Posted by Chris D on January 24, 2002 1:11 PM

fickle *and* some

I have this checked, as I like the feature

it works on my machine at work (Excel 97, Win 95, Novell) but not on my machine at home (Excel 97, Win ME)

Just a simple list of name :


starting in cell A1

will not autocomplete if I begin typing : "An" in cell A10


Posted by Mike Golding on January 24, 2002 6:04 PM

It looks like you have some blank cells before your next entry. I think it only works if there are no blanks. Mike.

Posted by Chris D on January 25, 2002 11:49 AM

Ahhh Mike, of course

and when there *are* blank cells, then the right-clicked "pick from list" takes over