Hi,

Select the filtered data, Press Ctrl and drag to a new location, to check
whether the visible data is copied to a new location.

Challa Prabhu

" wrote:

Myself and a person I work with just installed Excel 2007. If I
filter a sheet and copy the filtered data, Excel will only copy what
is visible. If I try it on my friends computer (using the same
methods and data), his Excel copies all the data, not just the
filtered rows. Any ideas?