Address List

Question

How to organize my address list columns, e.g. E column becomes A and C column becomes B etc.

Answer 1

To reorganize columns so that, for example, column E becomes column A and column C becomes column B, use sorting or cut/paste on entire columns rather than moving only the cells.

One practical way is:

1. Insert temporary helper columns if needed so data is not overwritten when moving.
2. Click the column letter at the top (for example, E) to select the entire column.
3. Use Cut (Ctrl+X) and then select the destination column letter (for example, A) and use Insert Cut Cells so the whole column shifts into that position and other columns move right.
4. Repeat for other columns (for example, cut column C and insert it at B) until the columns are in the desired order.

If the goal is only to view or analyze data in a different order (not physically move columns), create a copy of the data as an Excel table and then sort by the columns in the order needed:

1. Click any cell in the data range.
2. On the Data tab, select Sort.
3. In the Sort dialog, under Sort by, choose the first column to sort on, then set Sort On and Order.
4. Click Add Level to add more columns (for example, sort by the column that is currently E, then by the column that is currently C, and so on).
5. Select OK to apply the multi-column sort.

This keeps the columns physically where they are but orders the rows based on the chosen columns.

---

References:

• Sort a list of data in Excel for Mac
• Use a screen reader to sort or filter a table in Excel