How to Automatically Sort a List Alphabetically in Microsoft Excel. When you are organizing data for your company in a spreadsheet using Microsoft Excel, you do not have to manually edit the ...

To sort the last names alphabetically in ascending order, choose "A to Z." Click on the "Add Level" button at the top of the Sort dialog box to add a third sorting criterion.

Not all sorts in Excel are alphabetical. Sometimes, you need to sort by an irregular set of terms, and when that happens, you need to create a custom sort. Here's how.