Tweaking of provided excel spreadsheet

I am looking to have a current spread sheet provided to be easy to navigate. I will need to be quick with input and I cannot sit and scroll through the drop downs to find the specific one needed. I am looking to be able to type the first few words into the drop down fields and it populates the drop down to narrow down. It is nice to have the drop down lists on the 2nd tab so I can edit their content easy so hopefully we can keep that

Thank you.