Filter-Copy-Paste Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Or use the shortcut
Alt ;

Strange that there are more people with this problem in 2007 Jim
 
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.
| >
| >
 
Back
Top