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.

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.

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.

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.
|
|