Putting Names in Alphabetical Order in Microsoft Excel

By Nick Peers

Excel lists can be organized in various ways.
i finanzen, zahlen image by Alta.C from Fotolia.com

If you have a list of names in your Excel spreadsheet, you can put the names in alphabetical order by using the Sort feature. You can sort the list in ascending or descending order. To maintain the integrity of your data, you must sort all columns in the spreadsheet at the same time when you sort the list of names. You can also sort only the list without changing the order of the values in the other columns.

Step 1

Open the spreadsheet you want to edit in Excel. To open a spreadsheet, press "Ctrl-O."

Step 2

Select the entire spreadsheet if you want to maintain the integrity of the data. When you sort the list of names, all other columns will be sorted automatically.

Step 3

Click the "Data" tab and then click the "Sort" button in the "Sort & Filter" group to open the Sort window.

Step 4

Check the "My data has headers" if your spreadsheet has headers. Headers will not be sorted.

Step 5

Select the column that contains the names from the "Sort By" drop-down box in the Column field.

Step 6

Select the order from the "Order" drop-down box. The "A to Z" option puts the names in ascending order, while the "Z to A" option puts them in descending order.

Step 7

Click "OK" to sort the names and put them in alphabetical order. Verify the data and then press "Ctrl-S" to save the changes.

×