Sort a Complete Data Range on Windows
Sort related fields as a complete range so each amount stays attached to its item. In this example, the expense header is row 1, the five data rows are rows 2 through 6, and the Total row is row 7.
For matching example data, use the Practice workbook section at the end of this guide.
Sort the item names
Open a fresh working expense workbook.
On Expenses, select A2:E6, including all five fields for every expense.
Choose Data → Sort → Sort A → Z. The command sorts by the first selected column, A.
Check the resulting order before saving.

The selection includes every related data column and excludes the header and total.
Check the row relationships
The expected order is Desk lamp, Notebook, Paper, Pens, and Storage box. Desk lamp should still have amount 45 and owner Jordan. Paper should still have amount 12 and owner Alex.
The Total row stays outside the sort range and remains 100. Undo immediately if the fields are no longer paired as intended, then check the selected range before trying again.
Save the order
Press Ctrl+S. Reopen the workbook and inspect several item-and-amount pairs, rather than checking only the first cell.
Practice workbook
To reproduce this example, start with a separate practice copy. On Ulet Home, choose Sheets. Rename the first worksheet Expenses and enter the following values in A1:E6. Enter amounts as numbers.
Item | Amount | Category | Owner | Status |
|---|---|---|---|---|
Paper | 12 | Supplies | Alex | Complete |
Pens | 8 | Supplies | Sam | Complete |
Desk lamp | 45 | Equipment | Jordan | Planned |
Notebook | 15 | Supplies | Alex | Planned |
Storage box | 20 | Equipment | Sam | In progress |
Enter Total in A7 and =SUM(B2:B6) in B7. The initial total is 100. Column widths, colors, and number formatting are presentation choices; the values and cell addresses are what the exercise depends on.
Press Ctrl+Shift+S to choose a practice folder and save as Riverside-Expense-Tracker.xlsx. Reopen this named copy before following the exercise above. Keep your original documents separate.

