Thread
:
How do you copy filtered data to a new sheet?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Ron de Bruin
external usenet poster
Posts: 11,123
How do you copy filtered data to a new sheet?
Another one with this problem in Excel 2007
With one cell selected in your data table use
Ctrl * to select all the data
Then Alt ; to select all visible data
Then copy and paste
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Kerry B" <Kerry
wrote in message ...
In Microsoft 2000, I could filter data and then copy it to a new worksheet
getting only the data showing on the screen. I am now using Enterprise 2007
and am trying to do the same. Everytime I try this, it copies all the data,
not just the data on the screen that excluded the data I have filtered out.
Are there any tricks for being able to do this as easily in Enterprise 2007
as I did in 2000? Any help would be greatly appreciated. Thanks!
Reply With Quote
Ron de Bruin
View Public Profile
Find all posts by Ron de Bruin