View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Filter-Copy-Paste Problem

Strange...

Yes it is, Ron. No idea why though.

--
Jim
"Ron de Bruin" wrote in message
...
| 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.
|
|