Filter, Copy and Paste

[jknapp1005]

I'm trying to copy and paste something I've filtered in a spreadsheet. I've
done it before, but for some reason, it won't cooperate now. I'm using 2007,
if that makes any difference. I'm filtering one of the columns, copying the
using paste special. I've pasted using Paste Special, the Values and Number
format. Normally that will paste in only the filtered rows. This time it
continually pastes in the pre-filtered list. It's maddening. How can I paste
only what I've filtered or sorted?

 

[Ron de Bruin]

If it copy all the data (there are a few reports of 2007 users)
Use also the shortcut Alt ;
or use F5>Special>Visible cells only>OK to select only the Visible cells.

 

[jknapp1005]

That worked. Thanks, Ron!

If it copy all the data (there are a few reports of 2007 users)
Use also the shortcut Alt ;
or use F5>Special>Visible cells only>OK to select only the Visible cells.