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.

How to Create Pulldowns in Excel. You can create a pull-down menu in Microsoft Excel 2010 by configuring a list of values in the Data Validation menu.