After Filter
 

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?

After Filter
 

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.

After Filter
 

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

After Filter
 

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" wrote:

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.

After Filter
 

On Jun 24, 3:59 pm, Ask MS wrote:
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.