Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy/Paste auto filtered range (2k7)

    When I try to copy/paste an auto-filtered range of cells, I get all of the original data however I only want to see the filtered data. I searched and found how to do it in 2k3 but anyone know how to do it in 2k7? The same options aren't so easy to find...
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copy/Paste auto filtered range (2k7)


  3. #3
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy/Paste auto filtered range (2k7)

    wow, that's a lame bug. Thanks for the link Hans, I can't believe MS left an issue like this in Excel... I mean, when would you want to copy hidden filtered data?! (rhetorical)
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Copy/Paste auto filtered range (2k7)

    You can also use Alt+; as a shortcut to select only the visible cells if that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •