Ulet User Guide

Get started with Ulet for Windows.

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

  1. Open a fresh working expense workbook.

  2. On Expenses, select A2:E6, including all five fields for every expense.

  3. Choose Data → Sort → Sort A → Z. The command sorts by the first selected column, A.

  4. Check the resulting order before saving.

English expense table sorted by item name with each amount, category, owner and status kept on its original item row

View screenshot at full size

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.

Ulet

Your all-in-one office suite for everyday productivity.

See features