After Filter

[Ask MS]

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?

 

[Spiky]

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.

 

[Dave Peterson]

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]

Thanks, Spiky. A further question: after I select the visible cells as you
suggested (for example, a few cells A5, 7, 9, 10 in column A), I want to copy
and paste them, in exactly the same order, into a differnt column, (i.g. into
D5,7,9,10) What should I do? This question is actually the one that bothers
me.

 

[Spiky]

Thanks, Spiky. A further question: after I select the visible cells as you
suggested (for example, a few cells A5, 7, 9, 10 in column A), I want to copy
and paste them, in exactly the same order, into a differnt column, (i.g. into
D5,7,9,10) What should I do? This question is actually the one that bothers
me.

You should be able to copy after getting just the visible cells
selected. But they will paste to 4 cells in a row, not the way you
suggest. I don't think there is a simple way to paste like that,
whether rows are hidden or not.