We show you how to use drop down lists in Excel - creating, applying, updating and extending them.

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.

How to Insert a Combo Box in Excel 2010. Combo boxes are a useful way of entering data into an Excel spreadsheet, combining the flexibility of a text field with the convenience of a list box.

The Paste Special dialog box opens and displays several pasting options.Click "Validation" followed by "OK." Excel copies the drop-down list to the cells you selected.

– Select Options from the drop-down menu – In the Excel Options dialog box, select Customize Ribbon – In the right pane, check the box next to Developer – Click OK to save changes Step 3: Insert ...

You can also access functions. How to use Name for quick access to common functions in Excel Excel’s Name box automatically lists common functions in the dropdown when you enter the equals sign.