Or use the shortcut
Alt ;

Strange that there are more people with this problem in 2007 Jim



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jim Rech" wrote in message ...
Now it pastes everything regardless of the filter.

It doesn't for me but if I had this problem I'd do an {F5}, Special, Visible
Cells Only before the Copy.

--
Jim
"Thad Meyers" <Thad wrote in message
...
| In Excel 2007 how do you paste filtered data into a new worksheet without
| pasting all the rows? In previous versions the copy - paste function on
| filtered rows only pasted the information that was displayed with the
filter
| on. Now it pastes everything regardless of the filter.