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