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

[Guest]

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.

 

[D Hilberg]

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

 

[Guest]

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.

 

[Guest]

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.

 

[Dallman Ross]

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.