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?

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"jknapp1005" wrote in message ...
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?

That worked. Thanks, Ron!

"Ron de Bruin" wrote:

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"jknapp1005" wrote in message ...
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?