Excel Auto Complete Text when typing on the Dropdown list
<p>I have a excel input data which allows users to choose an item with Dropdown List (Done by Data Validation -> List). </p>

<p>However I wanted it to have a auto complete function such that when user were to key in the first few letters in the cell, the list would auto detect the suitable value for user to input. This would also solve the issue if user were to enter the wrong case for the Input (eg: Cost oF SaLe instead of Cost Of Sale as there is no validation for case sensitivity). Please see the screenshot below:</p>

<p><a href="https://i.stack.imgur.com/D3A6g.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/D3A6g.png" alt="enter image description here"></a></p>