After Filter

  • Thread starter Thread starter Ask MS
  • Start date Start date
A

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?
 
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?
Click to expand...

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?
 
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.
 
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.
Click to expand...

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.
 
Back
Top