| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Complete Question
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Complete Question
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Complete Question
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Complete Question
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to link Auto Filter values to a Cell | Excel Worksheet Functions | |||
| Auto Filter Question? | Excel Discussion (Misc queries) | |||
| How do I get a field in excel to auto complete with a check mark | Excel Discussion (Misc queries) | |||
| Excel auto calculation formula question. | Excel Worksheet Functions | |||
| Auto Filter Limit Question | Excel Discussion (Misc queries) | |||
Linear Mode
