An curved arrow pointing right. Data validation in Excel allows you to create drop-down menus right inside individual cells. You can also restrict the types of values entered into different cells.

Excel will automatically populate instructions to sort data by Column A from A to Z. 6. Click the "Column" drop-down menu to change to Column B (or another column if you have more than two).