Ulet-Benutzerhandbuch

Erste Schritte mit Ulet für {platform}.

Filter a Worksheet by a Column on Windows

A filter narrows the rows currently shown in a worksheet. This example displays only the expenses marked Complete, using the Status column of the Riverside workbook.

For matching example data, use the Practice workbook section at the end of this guide.

Choose the matching status

  1. Open a fresh working expense workbook.

  2. On Expenses, select A1:E6, including the header and all expense rows.

  3. On Data, choose Filter to add controls to the header.

  4. Open the filter control on the Status header.

  5. Clear Select All, select Complete, then choose Confirm.

English expense worksheet filtered to show the Paper and Pens rows whose status is Complete

View screenshot at full size

The visible expense rows match the chosen status; the other expenses are retained.

Check what the total means

The matching rows are Paper, amount 12, and Pens, amount 8. The workbook's existing SUM formula includes the hidden expenses too, so its Total row remains 100.

Filtering changes which records you view. It does not make that existing SUM formula a total of only the visible rows.

Show all expenses again

Open the Status filter again, choose Clear Filter, and check that all five expense rows return. Use the full view when you need to review or compare the complete source data.

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

Ihr Office-Paket für produktives Arbeiten im Alltag.

Funktionen ansehen