data-filter -autofilter-waht is acutally happening

Hello!
Sorry, the function works for selected column (before restarting it did not!!!)
but what is problem now is that from all other columns I SEE JUST THOSE ROWS WHERE THE CHOSEN VALUES OF THE SELECTED COLUMN ARE.

lIKE:

A B
1 7
2 8
3 9

So if I choose 7 in B, then I see just:

A B
1 7

Is that ok? Should it work like that?
Many thanks!!
(p.s. I really dont know what was before, I selected the column, but never mind, it is obviously instable…and I am working aon a bad pc)

Yes, this is normal. The filter works so - hide rows that don’t match the specified filter criteria.