Address List

Question

How do I organize my spreadsheet columns and my address list in alphabetical order

Answer 1

To alphabetize an address list in Excel, sort the data by the column that contains the names (or other field) you want to organize.

1. Make sure each column has a heading (for example: Name, Street, City, etc.).
2. Click any cell inside your address list.
3. On the ribbon, go to Data > Sort (or Sort & Filter > Sort).
4. In the Sort dialog:
   • Under Column, choose the column you want to sort by (for example, the Name column).
   • Under Sort On, leave Cell Values selected.
   • Under Order, choose A to Z to sort alphabetically from A to Z.
5. Click OK.

If you want a secondary sort (for example, first by Last Name, then by First Name):

1. In the same Sort dialog, after setting the first column, click Add Level.
2. Choose the second column under Then by, set Order to A to Z, and click OK.

This keeps each row together while arranging the entire address list in alphabetical order.

---

References:

• Sort data in a range or table in Excel
• Introduction to Excel Starter