How to Undo Filters

[Gatekat]

I’m in Calc and have a list of names. After using a standard filter to find all the entries with a space in them (full names) I can’t work out how to show the full list again. I have tried:

• Data → More Filters → Reset Filter

• Data → More Filters → Standard Filter → clear button

• Data → More Filters → Standard Filter → manually Xing the filter line

• Format → Rows → Show (while highlighting everything)

There are still a lot of missing rows. Any help would be welcome.

[Wanderer]

@Gatekat

There are still a lot of missing rows

Select the complete sheet by click on tze upper left edge (left from A, above one). Then use the context menu of the row-headers to unhide all rows.
.
Should work, because the filter hides the rows…