nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Sign in to vote on this idea

Restore Autocomplete Functionality

amwalgrave

Restore the autocomplete/typing functionality for dropdown/multi-select items. Typing no longer brings up the the word you're typing but any/all words with the consecutive letters you are typing so if you have a very long list of items in your multi-select and you need to select the 'NA' option, all list items with the consecutive letters 'na' will appear.

I used to be able to very quickly move through my data entry and now I have to stop many times and correct errors or validate that I have selected the correct items. Please restore the previous functionality or allow users to choose how to enable the autocomplete functions for their sheets.

Find more posts tagged with

Sheets

functionality

Idea Submitted

Enhancement Request

Comments

Jackie9

It appears that the autocomplete has changed for some of my dropdown list columns. It shows all of the words that contain the letters being typed instead of just the words that begin with the letters being typed.

For example, I used to be able to type "N" (for NA) in a column and have just "NA" populate - which is what I needed. I could hit enter, and move on, zipping through my data entry.

Now when I type "N" for "NA" in columns that contain other words containing "N", I have to stop, arrow down to "NA" and select it that way - because there are also words that contain "NA", so I can't just type "NA" and carry on.

This has GREATLY REDUCED MY DATA ENTRY EFFECIENCY and GREATLY INCREASED DATA ENTRY ERRORS. When I start typing letters in a dropdown list column, it should only bring up the words that BEGIN with the letters I'm typing NOT CONTAIN. If I type "N" for "NA" the word "Calibration" should NOT be the first option.

Other users have also expressed this same problem. Either change it back to the way it was or give users the option to choose how they want their auto-complete for drop down columns to work.

Becky M

Change it back - when I type the first few letters in a word, it should be the first letters of the word that comes up, not the first occurrence of the letters in the middle of a word.