A filtered sheet can hide a row because of a condition in any filtered column. A value that passes the visible column’s rule may still fail another active rule.
Inspect the whole filter
Check each filter control across the range. Review selected values, condition-based rules, and color filters. Search inside a filter’s value list if an expected item is difficult to find.
Check whether you are using the shared filter or a filter view. Close the view or temporarily remove the relevant condition in a controlled test, recording the original settings first if others rely on them.
Separate filtering from hidden rows
Inspect row-number gaps and hidden or grouped sections. Manually hidden rows are a different mechanism from a filter. An unexpected disappearance may also come from the filter’s source range excluding part of the dataset.
Compare the actual cell value with the condition. Spaces, text numbers, blank strings from formulas, and genuine empty cells can look similar. Do not change the record merely to force it through a rule whose meaning has not been checked.
Restore the intended population
Test a known included record and a known excluded one. Verify the displayed row count and the underlying source count. Removing a filter reveals data; it does not recover records that were deleted or were never in the range.
Shared filter changes affect other users, so use a personal filter view for exploratory checks where suitable. Do not delete validation or formatting rules as a blanket response to missing rows. Make the smallest change that explains the actual condition, then verify that the restored rows still have the correct associated fields.
References
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.