A filter creates a view of records that meet your criteria. Write down the question first, such as “Which open tasks belong to Maya?” Then check the visible rows against that question.

Keep the complete source table available. A filtered view can hide records that still matter to someone using the file later.

Filtering the sample task list to Open and Maya leaves T1 visible.

Example view for open work assigned to Maya. Original instructional illustration.

Try two criteria on three records

ID

Status

Owner

T1

Open

Maya

T2

Closed

Maya

T3

Open

Leo

Filter Status to Open and Owner to Maya. T1 matches both criteria. T2 fails the status criterion, while T3 fails the owner criterion.

Apply the filter to the intended table

Identify the complete range and its header row before using the editor's filter controls. Check for blank separators or merged cells that could complicate the range.

Filtering changes which rows you see. It does not, by itself, delete the nonmatching records. If you need a separate extract, decide how that copy will be created and labeled.

When a match is missing, check other filters, stray spaces, inconsistent labels and data types.

More than one criterion can affect the view. Original instructional illustration.

Investigate a missing record

Look at filters on every relevant column. An older filter can remain active while you add a new one.

Then check the actual values. Extra spaces, inconsistent labels or dates stored in a different form can prevent an expected match. Compare a known matching record and a known nonmatching one with the displayed results.

Check totals separately

A total may include more rows than the view displays, depending on its formula. Label the total according to what it includes and verify it with a small sample. Do not infer its definition just from the rows currently visible.

Prepare the view for handoff

  1. Record the active criteria and reporting date.

  2. Confirm a few known records and the visible count.

  3. Explain whether the recipient should see the filtered view or the complete table.

  4. Reopen the saved file and check the intended view.

Ulet lets you review and organize local spreadsheets on Windows and macOS. Use Ulet Spreadsheet Editor.

Microsoft’s guide to filtering a range in Excel.