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

Click the "OK" button to create the drop-down list for the selected cell or group of cells on the worksheet, or "Sheet2." Save the workbook. Hover over a cell to reveal the drop-down list box.