Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy visible cells on Filtered data
Myself and a person I work with just installed Excel 2007. If I
filter a sheet and copy the filtered data, Excel will only copy what is visible. If I try it on my friends computer (using the same methods and data), his Excel copies all the data, not just the filtered rows. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy visible cells on Filtered data
There are a few people that report this in the newsgroups
I have no solution for you Workaround: You can select your filtered data like this Select a cell in the table and use Ctrl * If there are no empty rows/columns in your data table all cells are selected Then use Ctrl ; to select the visible data Then Ctrl c to copy and paste it where you want with Ctrl v -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message ups.com... Myself and a person I work with just installed Excel 2007. If I filter a sheet and copy the filtered data, Excel will only copy what is visible. If I try it on my friends computer (using the same methods and data), his Excel copies all the data, not just the filtered rows. Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy visible cells on Filtered data
Hi,
Select the filtered data, Press Ctrl and drag to a new location, to check whether the visible data is copied to a new location. Challa Prabhu " wrote: Myself and a person I work with just installed Excel 2007. If I filter a sheet and copy the filtered data, Excel will only copy what is visible. If I try it on my friends computer (using the same methods and data), his Excel copies all the data, not just the filtered rows. Any ideas? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy visible cells on Filtered data
Select your filtered data. Press F5 key. click on "Visible Cells Only". Copy
that data and paste anywhere. Tell us if it works..... " wrote: Myself and a person I work with just installed Excel 2007. If I filter a sheet and copy the filtered data, Excel will only copy what is visible. If I try it on my friends computer (using the same methods and data), his Excel copies all the data, not just the filtered rows. Any ideas? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy visible cells on Filtered data
Select your filtered data. Press F5 Key. click on Special button. then click
on "Visible cells Only". copy and paste data. " wrote: Myself and a person I work with just installed Excel 2007. If I filter a sheet and copy the filtered data, Excel will only copy what is visible. If I try it on my friends computer (using the same methods and data), his Excel copies all the data, not just the filtered rows. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I only delete/clear the visible cells in a filtered list? | Excel Worksheet Functions | |||
Copy/Paste Visible cells only | Excel Discussion (Misc queries) | |||
Copy visible cells only | Excel Discussion (Misc queries) | |||
Help to adapt Formula syntax to work with Visible Filtered Cells | Excel Worksheet Functions | |||
average of visible cells in a filtered range | Excel Worksheet Functions |