To help users enter data in a spreadsheet, you can create drop down lists with Excel's Data Validation feature. For example, in an order form, you could provide drop down lists of customers, products, colours, sizes and shipping methods.

Usually, each of these lists would need a different Source in the Data Validation dialog box. [...]