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.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.