| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Filter Results only
How do I set the filter so that I can copy only the filter results vs. the
filter results & the underlying data that was hidden. -- Mauren |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Filter Results only
Autofilter results?
My Excel 2003 you just select the rows you see and copy/paste. If you can't do that for dome reason, F5SpecialVisible cells onlyok. Copy/paste. Gord Dibben MS Excel MVP On Mon, 12 Nov 2007 16:31:19 -0800, Maureno wrote: How do I set the filter so that I can copy only the filter results vs. the filter results & the underlying data that was hidden. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Filter Results only
Once you have filtered your data, highlight the visible cells that you
want to copy (plus maybe the headings) and click <copy. Then move your cursor to where you want the data to be copied to (maybe in another sheet) and just press <Enter. You should see only the filtered data in the pasted range. Hope this helps. Pete On Nov 13, 12:31 am, Maureno wrote: How do I set the filter so that I can copy only the filter results vs. the filter results & the underlying data that was hidden. -- Mauren |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Filter Results only
I am using Office 2007. Everything was fine in 2003. Now, I see this
problem--even when I follow your instructions. The visible cells only option doesn't seem to work either. -- Mauren "Gord Dibben" wrote: Autofilter results? My Excel 2003 you just select the rows you see and copy/paste. If you can't do that for dome reason, F5SpecialVisible cells onlyok. Copy/paste. Gord Dibben MS Excel MVP On Mon, 12 Nov 2007 16:31:19 -0800, Maureno wrote: How do I set the filter so that I can copy only the filter results vs. the filter results & the underlying data that was hidden. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Filter Results only
I am using Office 2007. Everything was fine in 2003. Now, I see this
problem--even when I follow your instructions. -- Mauren "Pete_UK" wrote: Once you have filtered your data, highlight the visible cells that you want to copy (plus maybe the headings) and click <copy. Then move your cursor to where you want the data to be copied to (maybe in another sheet) and just press <Enter. You should see only the filtered data in the pasted range. Hope this helps. Pete On Nov 13, 12:31 am, Maureno wrote: How do I set the filter so that I can copy only the filter results vs. the filter results & the underlying data that was hidden. -- Mauren |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
| Filter data & sum or avg the results? | Excel Worksheet Functions | |||
| Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
| Filter Results in Status Bar | Excel Discussion (Misc queries) | |||
| How do I show the results of filter? | Excel Discussion (Misc queries) | |||
Linear Mode
