How to stop cells from memorizing text input

Hi Shen,

You can turn this off by unchecking the 'Show suggestions when editing table cells' via Numbers > Preferences in your menu:

SG

Numbers builds the 'suggestion list' for each column using what has been entered in other cells in the same column. It's not possible to "erase the memory of certain words" except by removing that word from any cells (in the same column) containing it, which is not usually a practical solution.

"Sometimes, the drop down menu also gives me the same word twice" indicates the two entries are not identical—possibly due to a trailing space (or other invisible character) in one of the cells containing it.

Turning the feature off and on as needed, using the Numbers Preferences setting pointed out in SG's post above can work well.

An alternate method is to remember that these are 'suggestions.' Depending on the situation, you can choose to select one of the suggestions (using the mouse/trackpad or the arrow keys), or simply continue typing until what's in the cell is what you want, then press return to confirm and move on to the next cell.

Example: The active cell (B7) shows what was in the one above it , and the same list of choices, as the one above it did when I pressed return, The result is seen in B6.

Regards,

Barry

If you want to limit what you input to specific values (and choose from a list to prevent typos and speed up entry) then you can also format the column as Pop-Up Menu. Enter your values in cells, select them, and format. That fills the list automatically.

Then when entering a value in a new cell in that column you hit the space bar and type a letter to make your choice from the list.

SG