Follow the steps below to create a drop-down list using data validation in Excel. If you want to add a message pop up, you can click the Input Message tab and check the checkbox for “Show input ...

Write down your options in the Source box. Save your change. To get started, you need to select a cell in your spreadsheet where you want to show the drop-down list.

Microsoft Excel can save you time in lots of little ways, like adding a drop-down list to cells so that only pre-written text can be entered.

How to Create a Drop-Down Box With Color. One way to streamline data entry is to create custom lists in Excel and use them to create drop-down lists in specified cells.

In Excel 2007, click the round Office button, and then click the Excel Options button at the bottom of the drop-down menu. Once you’re in the Options dialog box, select Formulas in the left pane ...