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?

On Jun 24, 2:09 pm, Ask MS <Ask M...@discussions.microsoft.com> 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.

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

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 M...@discussions.microsoft.com> 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.
>

On Jun 24, 3:59 pm, Ask MS <As...@discussions.microsoft.com> 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.