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 ... working with linked Excel files ...

With the Developer tab enabled, you can now access the necessary tools for creating forms ... to open the Excel Options dialog box. In the Choose commands from drop-down list, select All Commands.