Sorting tabular data using a dropdown menu?

1. How do I arrange a drop down list in Excel?

How do I arrange a drop down list in Excel?

Select the cell where you want a drop-down list. Click Data Validation, select List, click in Source, press F3, select the name, click OK, and click OK again. Verify the cell contains the drop-down list with the entries provided by the named range, and copy the list to the other cells.