| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and Paste Filtered Cells in Excel 2007
I have filtered a large list and want to copy the contents of the cells
containing the filtered criteria into the adjacent column so that I can correct them whilst leaving the original data intact. I know how to 'go to' - 'visible cells only' and then copy, but when I paste the data it is not pasting into the filtered rows. For example, my filtered row numbers run from 408, 1608, 1711, 2069 and there are about 300 records that meet the filter criteria. When I paste the records, they are simply being pasted into row 408 - 708. Thanks, hopefully. Gillian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy and paste filtered data | Excel Discussion (Misc queries) | |||
| Dificulty in copy and paste when items is filtered in excel 2007 | Excel Worksheet Functions | |||
| using macro to copy and paste filtered results, what if blank? | Excel Worksheet Functions | |||
| Excel 2007: copy/paste formatted cells? | Excel Discussion (Misc queries) | |||
| Issue with copy/paste dates from filtered data | Excel Discussion (Misc queries) | |||
Linear Mode
