Excel sheets - Autocomplete feature similar to Google Sheets -- 2

I have an Excel workbook that list all my expenses by month (one sheet by month) and by account (one table by account [bank account, credit card, cash]). I want to improve the autocomplete feature for the Subcategory column, to have a user experience similar to this Google Sheet example: [login to view URL] Currently I am able to use autocomplete feature by simply copy-pasting the list of options below the entries in the table, in the same column. But this approach is not clean, and I don't have dropdown option like in the Google Sheet example. I want to avoid doing this and also having a dropdown as in the the Google Sheet example. Requirements 1 - Autocomplete feature like the Google Sheet example (No need to click on the "drop-down" button) 2 - Dropdown option like the Google Sheet example 3 - Apply 1 and 2 to Subcategory columns (all sheets in workbook) 4 - Remove the unnecessary list in the table below the entries 5 - Don't break existent entries and features! 6 - Must be compatible with Excel for Mac