Hello,
I would like to ask, if it is possible to disable whispering of already used words/numbers for only only selected columns.
When I start writing in a cell, the whispering offers to write the words/numbers, if the same word/number is already written on the sheet. The whispering is helpful in some columns, which always repeat same two words, but in other columns it is very annoying and often leads to mistakes.
Thank you.
Regards
M.
Perhaps you mean AutoInput? You can switch the state of this from the menu. Or you can assign a hotkey for this (for example, F3) and simply press the button if the whisper interferes with your work.
The English term is “Auto Input”. Turn it off and use validation instead.
Write the values into a cell range.
Call menu:Data>Validitiy…
and validate by cell range.
If you are dealing with many different values:
Select the data.
menu:Data>Filter>Standard Filter…
And use the following settings:
This will copy values from column A to cell V1 without duplicates. Then you can use this list of unique values with the validation feature.
