cancel a filter in calc

I have set a filter that is now showing two filtered rows. When I follow the help and
“click inside the area where the filter was applied, then choose Data - Filter - Reset Filter.”
reset filters is greyed out.

Your cursor should be in the area for which you have set the filter.

Yes, I am doing that as I said but Reset Filters is greyed out.

The only way seems to be to select the entire spreadsheet then Fromat-Rows-Show but that affect hidden rows etc. How do I ungrey Reset filters?