When I click on a cell in Numbers (v. 6.1) on my iMac (v. 14.5) I get a large choice of autofills consisting mainly of the typos I made in the past. How do I edit the autofill in Numbers, to eliminate the choices that are obvious typos and other errors.
iMac 21.5" 4K, macOS 10.14
You screenshot helps but it doesn't show the entire column. There are clearly cells above what is shown in the screenshot and there are cells below. Almost certainly you will find cash Cash (probably with an extra space after it) and Cash 7.59 in those cells you aren't showing. (And perhaps you have filtered your table or hidden rows so you can't see everything there?).
SG
Numbers gets its suggestions from the entries you have made in cells above or below in that same column.
If you see typos in the suggestions then you have typos in what you have entered above or below. Go through and correct those typos in the same column above and below and all will be well.
SG
For example, when I start to type the word "Cash" in the fourth column on the last line of the spreadsheet for the item "Test," the drop down gives me the prior typo I made. There is nothing to correct above or below. (see last line of the spreadsheet below. Notice "Cash 7.59" is one of the choices, because I did not jump to the next column before entering the 7.59. This happened quite a while back. I corrected it in the cell at the time but "Cash 7.59" is always given as a choice.) I would like to know how to get rid of "Cash 7.59 as a choice in the drop down menu.
Thanks for getting back to me. I correct them in the column where I erred after I review the line of entries. They are in no other column above.
You are so correct. When I widened the column I discovered the Cash 7.59 entry, corrected it and now it no longer appears in the drop down menu. Thanks for your time and patience.
Glad you have it all sorted now. And thanks for the green tick!
SG
Not sure what you are saying. Just correct the errors (above and below) in the same column and the errors in the suggestions for new entries in that column will disappear.
SG
Eliminating some autofill choices in a cell
