General Question

nmguy's avatar

How do I prevent autofill in Apple's Numbers program?

Asked by nmguy (528points) 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

eponymoushipster's avatar

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.

jrpowell's avatar

Numbers—> Preferences—> General

Uncheck “Show auto-completion list in table columns”

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther