On Jun 24, 2:09 pm, Ask MS <Ask wrote:
Once we add "fileter", and get a incomplete list, we can't see the hidden
rows anymore, however, when we select multiple rows, the hidden rows are
still selected. Is there any way to "freeze" those hidden rows?

I think you are looking for Select Visible Cells. After selecting your
rows, you can hit F5 (goto), click on Special, and click on Visible
Cells Only. This will de-select the hidden rows, keeping the visible
ones.

There is also a toolbar button that is easier to use, but it isn't on
the standard toolbars. You'd have to add it using Customize.