How to add a drop down list in Google Sheets No formula is needed to create drop-down lists in Excel. All you need to do is ...

Dropdowns are useful features that simplify data entry and enforce data validations in spreadsheet software. Creating a dropdown list is easy. And you might have done that already in Excel.

Now, expand the Criteria drop-down menu, and select List of items ... Just like Microsoft Excel, Google Sheets allows you to create a drop-down list with color-coded values.