Let’s start from scratch. I’ll begin by creating a fresh dropdown list from a list of color options. If you’re not already sure how to add a drop-down list in Google Sheets, start with this ...

In the resulting popup, give your drop-down a name, an associated color, and add the necessary items to the list. Once you've finished, click Save and the new drop-down will be available for use ...

Creating a drop-down list in a Google Sheets cell can speed up your data input process and now it's easier to do than ever. We'll show you how.