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
Open a fresh working expense workbook.
On Expenses, select A1:E6, including the header and all expense rows.
On Data, choose Filter to add controls to the header.
Open the filter control on the Status header.
Clear Select All, select Complete, then choose Confirm.

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.

