Filter-Copy-Paste Problem

[Guest]

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.

 

[Jim Rech]

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

 

[Ron de Bruin]

Or use the shortcut
Alt ;

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

 

[Jim Rech]

Strange...

Yes it is, Ron. No idea why though.

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