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.

The Google Sheets iOS app supports selection of items from a list and data validation on entry, but does not include the ability to add new data validations to a cell.

Create a new Google Sheets document. Now, add the following headers to A1, B1, and C1: ‘Due date’, ‘Task’, ... Select the whole B column by clicking on the B on top of it.

Open your Google Sheets project, or create a new one by going to sheets.new. 2. Select the cell, or cells, where you want to add a drop-down list. 3. Right-click into one of these cells. 4. Select ...

While Microsoft Excel has to-do list templates, I’m partial to the ones provided by Google Sheets. The built-in checkboxes are hard for me to resist. It’s easy to format your list and make it ...

Create a drop-down menu in Google Sheets. Launch Google Sheets. Open a new spreadsheet or open an existing spreadsheet file. Select a cell where you want to create a drop-down list.

Image: Andy Wolber/TechRepublic. A drop-down list helps speed entry and standardize data in a Google Sheet. Select a cell, choose an item from the list, and continue on to your next task.

To do so, you can follow this tutorial to create a drop-down list in Google Sheets. You can create a single, colored as well as a nested drop-down menu with the help of this guide.