Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i paste only into visible cells in Excel?
I need to put data into a spreadsheet built and maintained by someone else
for a variety of uses. The rows I care about are not consecutive, but appear consecutive when the file is filtered. I compile my data in another spreadsheet and want to copy-and-paste into the first spreadsheet. To avoid having to tediously copy each row individually, I would like to be able to copy the entire data set from my own spreadsheet and then paste it into the first spreadsheet in a single operation. Is there a way to paste so that the values go only into the visible cells? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i paste only into visible cells in Excel?
Jeff,
Indeed xls will copy also hidden rows. Rather then writing difficult macro's that detect the rowheight = 0 for every cell, why don't you sort you data on the column that you use to filter? In that way all data that appears consecutive in the filter actually is consecutive - which enables easy copying. R "Jeff Becker" wrote: I need to put data into a spreadsheet built and maintained by someone else for a variety of uses. The rows I care about are not consecutive, but appear consecutive when the file is filtered. I compile my data in another spreadsheet and want to copy-and-paste into the first spreadsheet. To avoid having to tediously copy each row individually, I would like to be able to copy the entire data set from my own spreadsheet and then paste it into the first spreadsheet in a single operation. Is there a way to paste so that the values go only into the visible cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cut & Paste visible cells on same row | Excel Worksheet Functions | |||
Copy/Paste Visible cells only | Excel Discussion (Misc queries) | |||
how do I select, cut, and paste visible cells only | Excel Discussion (Misc queries) | |||
Paste into visible cells | Excel Discussion (Misc queries) | |||
Paste into Visible Cells Only | Excel Discussion (Misc queries) |