How do I paste a vertical list skipping over the hidded rows?
 

I am trying to copy a colume of data from a filtered list to a second
filtered list. But Excel keeps pasting into the hidden rows also. This second
list has every other row blank for hand written notes.

How do I paste a vertical list skipping over the hidded rows?
 

Yes, Excel isn't quite wysiwig in this case (and for good reason,
though it can be inconvenient when doing what you are attempting).

You could copy the hand-written notes into Comments (or drag the lot
of them to be side-by-side in an adjacent column) to get rid of the
intervening rows.

Sorry not to be more helpful,

- David

On Jul 15, 12:52 pm, Jerry1Gman
wrote:
I am trying to copy a colume of data from a filtered list to a second
filtered list. But Excel keeps pasting into the hidden rows also. This second
list has every other row blank for hand written notes.

How do I paste a vertical list skipping over the hidded rows?
 

I had a similar case as yours. But mine data was some numerical values, after
i perform the SubTotal to each categary, when then full listed (level 3), i
copy and paste (paste special) all the numeric columns as "values" only.
Then when i go to level 2 (all the subtotals) which is a filtered list, i
copy all the data and paste again, it only gives me the filtered list.
Hope this is useful for you. You can treat your data as subtotal too and try
out.

"Jerry1Gman" wrote:

I am trying to copy a colume of data from a filtered list to a second
filtered list. But Excel keeps pasting into the hidden rows also. This second
list has every other row blank for hand written notes.

How do I paste a vertical list skipping over the hidded rows?
 

Select the cells you want to copy. Press F5 key, click on Special Tab and
click on Visible Cells Only. Then copy it and paste.

"Jerry1Gman" wrote:

I am trying to copy a colume of data from a filtered list to a second
filtered list. But Excel keeps pasting into the hidden rows also. This second
list has every other row blank for hand written notes.

How do I paste a vertical list skipping over the hidded rows?
 

In .com, D
Hilberg spake thusly:

Yes, Excel isn't quite wysiwig in this case (and for good
reason, though it can be inconvenient when doing what you are
attempting).

I don't really follow the limitation you are suggesting. In
Excel 2002, I just filtered a list, copied the rows, and pasted
them into a new worksheet, and only the filtered rows were pasted
into the new sheet. That seems to be what the OP wants.

--
dman

=================
You could copy the hand-written notes into Comments (or drag the
lot of them to be side-by-side in an adjacent column) to get rid
of the intervening rows.

Sorry not to be more helpful,

- David

On Jul 15, 12:52 pm, Jerry1Gman
wrote:

I am trying to copy a colume of data from a filtered list to a
second filtered list. But Excel keeps pasting into the hidden
rows also. This second list has every other row blank for hand
written notes.