In the Google Sheets app on Android, tap the vertical three-dot menu, then tap Data Validation to configure drop-down items or validation options for selected cells. 2.

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

This opens the “Data validation rules” sidebar, and you can make changes to the dropdown, such as changing items’ values or colors. To delete the dropdown from your spreadsheet, click Remove ...

Select dates quickly with this handy feature. Method 2: Use Data Validation . While changing the cell format to add a date picker is a quick method, it requires the cell to have data already present.

Navigate to Sheets menu and click on the option Data. Select Data Validation from the drop-down menu. A Data Validation window pops up with several options to customize.

Here's how for Google Sheets: 1. Highlight a column or click the capital letter at the top of the column. 2. Click the down arrow to open the dropdown menu. 3. Choose Sort sheet A-Z or Sort sheet Z-A.

The Data Validation feature in Excel 2013 offers a List option to confine selections in a cell to a ... Click the "+" sign at the bottom of Excel 2013 to create a new sheet to use as a data source.