SMALL LESSONS.
CLEARER DIGITAL DAYS.

A Spreadsheet Filter Hides Rows from View; It Does Not Delete Them

Conceptual illustration of a laptop lesson, notebook and small timer on a study desk.
AI-generated conceptual illustration, not a product screenshot.

A worksheet showed thirty entries yesterday and only eight today. Before assuming data has disappeared, check whether a filter is active. A filtered view can be useful precisely because it shows only the rows that meet a condition.

Name the condition you are seeing

Look for the filter indicators and read the selected values or rule. A list limited to “open” tasks is not the complete task register. Google’s sorting and filtering guide explains filters and filter views in Sheets; use your own application’s guidance for the exact controls.

Keep visibility separate from existence

Hidden rows still belong to the underlying data unless they have actually been deleted. Clearing the relevant filter should make matching exclusions visible again. Other hiding mechanisms can also exist, so a restored filter does not automatically explain every absent row.

Be especially careful when copying, filling or calculating over a selection. Operations differ in how they treat filtered or hidden rows. Test on a small example and inspect the result instead of assuming that every action affects only what you can see.

Share the context with the view

If you send a screenshot of the eight visible entries, state the filter condition. Otherwise, a colleague may read the picture as a complete list. In a shared workbook, understand whether changing the filter alters other people’s view or only your own.

This is distinct from sorting whole records: sorting changes order, while filtering changes which records are displayed. A good review note says both what was included and what was excluded. That makes a small view useful without allowing it to impersonate the entire dataset.