Restricted values autocomplete

JDGiants

New Member
Joined
Nov 11, 2013
Messages
7
Hi! Restricted values are working for column when selecting from the drop down menu in each cell. However, when keyboard entering first few char's, the correct value shows ("autocomplete"), but Excel does not accept it, and we cannot move to the next column in a table.

1600015725526.png


Details:
  1. 2 worksheets, first sheet has the target data ("AAA", "BBB", "CCC", "DDD") or such in lookup table.
  2. Second table has column to be filled with target data, and data validation works, as stated, with the dropdown menu in each cell.
  3. If, in the appropriate second table column, we type "bb", "BBB" is shown (correctly), but Excel does not allow us to tab/crlf to the next cell, instead giving the error msg above.
  4. We want to have the ability to keyboard in the first 2 or 3 chars and press <TAB>, for "auto-complete", and/or speed of entry.
Any/all solutions appreciated. Office 2013 version. Hope I was clear...

-JD
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,127,167
Messages
5,623,123
Members
415,956
Latest member
Footballtend

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top