Filter-Copy-Paste Problem
 

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.

Filter-Copy-Paste Problem
 

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.

Filter-Copy-Paste Problem
 

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.

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