Auto Complete Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Why would a single column in a worksheet not auto complete when all other
columns function correctly? Thank you!
 
No gaps in the data and either a numeric or the word "None"... All columns
except one will autocomplete when an "N" is entered. I have another worksheet
which when a new row is inserted some columns will continue a formula and
some not...
(Excel 2003)
--
If you can read this, thank a Teacher...
If your reading it in english, thank a Veteran!


Dave Peterson said:
Maybe you have gaps in the data???
Maybe you're using numbers in the data????
Click to expand...
 
I'd guess that there were too many numbers between the previous None and the
cell you're entering data into.

Debra Dalgleish posted these links:

This MSKB article has information on AutoComplete in Excel 97:
http://support.microsoft.com/default.aspx?id=177423

and for Excel 2000:
http://support.microsoft.com/default.aspx?id=212069


No gaps in the data and either a numeric or the word "None"... All columns
except one will autocomplete when an "N" is entered. I have another worksheet
which when a new row is inserted some columns will continue a formula and
some not...
(Excel 2003)
Click to expand...
 
Back
Top