Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - Copy and Paste repeatedly skipping cells | Excel Discussion (Misc queries) | |||
Copy while skipping Rows | Excel Discussion (Misc queries) | |||
Skipping rows with VBA | Excel Discussion (Misc queries) | |||
Can I paste data skipping the hidden cells ? | Excel Discussion (Misc queries) | |||
Trouble with skipping rows | Excel Worksheet Functions |