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.

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