Excel's drop-down menus are useful for creating order forms and navigation for larger files like records of sales. The options in the menus are references to cells elsewhere on the spreadsheet.

Select all the relevant cells, and in the Data tab, click the main part of the split "Data Validation" button. Then, click ...

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. An Excel ...