Add a Drop-Down List in Excel. If you prefer using Excel over Google Sheets, you can still use drop-down lists. The process is similar in Excel, but the data validation options look a little different ...

How to add a data validation drop-down in Excel Now that you know how users and your data will benefit from a drop-down list, let’s add one to D2. First, add the short list ( Figure A ) to B3:B6 ...

One type of data that is commonly found in an Excel spreadsheet is calendar data, ... click the cell where you want to add the date picker. ... Use Data Validation in Excel.

We’ll add a data validation control to this sheet. Click the Data tab, and then, click Data Validation in the Data Tools group. In the resulting dialog, choose List from the Allow dropdown.