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 ...

Drop-down lists are perfect for several purposes, such as inputting information into a form. Here's how to create a drop-down list using Microsoft Excel on Windows and Mac.