You can hit edit|goto (xl2003 menus) or ctrl-g or F5
then click special
then click visible cells only

To limit your selection to the visible cells in the selected area.

Is that what you meant by freezing the hidden rows?

Ask MS 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?

--

Dave Peterson