How do I prevent autofill in Apple's Numbers program?
Asked by
nmguy (
528
)
October 26th, 2009
I use Apple’s Numbers spreadsheet program and get irritated when filling a cell with text for a football pool that I’m in. When I type in game results, the previous game results automatically show up.
How do I eliminate this irksome problem?
Observing members:
0
Composing members:
0
2 Answers
Just keep typing, and it will overwrite the suggestion.
For example, if you have the “Bills” in your column, and you go to type the “Broncos”, the B will activate the “Bills” if you only have one “B” team. As you know, Numbers will offer “Bills” (with “ills” in blue highlight). To select that, hit enter; to ignore it, just keep typing.
Once you have several teams with similar names, when you start typing, a pop-up list should appear with your various options. Again, if you want, select one of those with your mouse or arrow keys. If you don’t want them, keep typing.
In short, that feature is basically “always on”, afaik. but you can somewhat ignore it.
Numbers—> Preferences—> General
Uncheck “Show auto-completion list in table columns”
Answer this question 
This question is in the General Section. Responses must be helpful and on-topic.