+ Reply to Thread
Results 1 to 2 of 2

Filtered data in excel 2007

  1. #1
    Registered User
    Join Date
    10-09-2017
    Location
    IDN
    MS-Off Ver
    2007 & 2010 & 2013
    Posts
    48

    Filtered data in excel 2007

    Hy all,

    i use excel 2007 for my work, and as i know, in excel 2007 we can't copy/cut then paste data, if the data is being filtered.

    as example, the data from A2:A20 contain formula. but rows A6, A9, A10 and A18 are hidden because filtered. when i want to copy all data A2:A20, then it can't paste values it in same location. i have to sort it first so the hidden cells are ordered, so i can paste value.

    is there any solution we can do paste values like excel 2010 or latest, without sort it?

    i attached an image to make it clear
    Attached Images Attached Images

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    6,766

    Re: Filtered data in excel 2007

    As you want to copy it to other location, why don't use advanced filter?
    It is in the same group as autofilter. the only requirement is that you have to write filtering rule into some cells.
    For instance if in yoyr samle filter was a>5 then in some two cells say A21 and A22
    write
    Please Login or Register  to view this content.
    and use this as filtering rule for advanced filter
    Best Regards,

    Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1