Alternatively, type a new list of data on a worksheet; click on the default worksheet name "Sheet1" at the bottom of the workbook. You can input data as a row or column.

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

These updates include enhancements for drag-and-drop functionality, inserting rows and columns, freeze panes, AutoFill, paste options, sheet views, comment filters, and a date picker.

To edit a drop-down list in Excel, you can use a number of tools depending on how you created the list. Here's what you need to know.