Filter, Copy and Paste

  • Thread starter Thread starter jknapp1005
  • Start date Start date
J

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?
 
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.
 
That worked. Thanks, Ron!

Ron de Bruin said:
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.
Click to expand...
 
Back
Top