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
Telobamipada wrote:
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" wrote:
Maybe you have gaps in the data???
Maybe you're using numbers in the data????
Telobamipada wrote:
Why would a single column in a worksheet not auto complete when all other
columns function correctly? Thank you!
--
If you can read this, thank a Teacher...
If your reading it in english, thank a Veteran!
--
Dave Peterson
--
Dave Peterson