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).