Copying Filtered Data in Excel 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chgofan - 21 Sep 2007 20:48 GMT

Help - I just upgraded to Office 2007. For some reason, when I filter data in
one of my worksheets and try to copy the filtered data into a new
spreadsheet, all teh rows in between my filtered data are copied to my new
spreadsheet as well and not just my filtered data. I never had this problem
in 2003. Any suggestions?

Thanks

Reply to this Message

Dave Peterson - 21 Sep 2007 22:08 GMT

I saw this response in a different forum:

> The key here is that if you select just the table (or cells in the same rows
> as the table) to copy, then you will get the filtered data.
[quoted text clipped - 7 lines]
> you see several 'mini-selections' inside a larger bold border, then you will
> get the filtered data.

> Help - I just upgraded to Office 2007. For some reason, when I filter data in
> one of my worksheets and try to copy the filtered data into a new
[quoted text clipped - 3 lines]
>
> Thanks

Signature

Dave Peterson

Reply to this Message

Chgofan - 24 Sep 2007 20:14 GMT

For some reason this only works part of teh time. There seems to be no rhyme
or reason as to when I am going to get teh entore spreadsheet or just teh
filtered area I am trying to copy. ANy suggestions as to what I may be doing
wrong.

> I saw this response in a different forum:
>
[quoted text clipped - 17 lines]
> >
> > Thanks

Reply to this Message

Dave Peterson - 24 Sep 2007 20:34 GMT

I don't use xl2007 enough to offer any tips.

Sorry.

> For some reason this only works part of teh time. There seems to be no rhyme
> or reason as to when I am going to get teh entore spreadsheet or just teh
[quoted text clipped - 26 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

RyGuy - 26 Sep 2007 15:54 GMT

I haven't used '07, but in '03, you just hit Ctrl+C and then right-click and
do click Paste Special, Values. You could also try Ctrl+G, Special, Visible
Cells Only, Ok, Ctrl+C, Ctrl+V. I would think some of these features got
carried over to '07.

Hope that helps.

Regards,
Ryan--

> Help - I just upgraded to Office 2007. For some reason, when I filter data in
> one of my worksheets and try to copy the filtered data into a new
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

Chgofan - 26 Sep 2007 19:06 GMT

Thanks - those steps seem to work. You would think they would have kept it
just as simple in 2007 version instead of making it a complicated step.
Thanks to all of you for your help.

> I haven't used '07, but in '03, you just hit Ctrl+C and then right-click and
> do click Paste Special, Values. You could also try Ctrl+G, Special, Visible
[quoted text clipped - 13 lines]
> >
> > Thanks

Reply to this Message