Microsoft Excel lets you create simple forms that your users can enter data. To save them time and make sure you get the information you need, you can create a drop-down box that limits the users ...

Select where you want the drop-down list to appear. Click the Data tab and select Data Validation in the Data Tools group. A Data Validation dialog box will appear.

To add the Forms command to your QAT, go to the QAT and click the drop-down arrow to open the customize menu. Select More Commands to open the Excel Options dialog box.