+ Reply to Thread
Results 1 to 3 of 3

auto filter is now working with merged cells

  1. #1
    Registered User
    Join Date
    02-07-2008
    Posts
    1

    auto filter is now working with merged cells

    Hi All,
    Below is a sample excel format. I enabled merge cells from A1..A5 and B7..B10. I enabled autofilter and when I filter with column A(Cat), I can see only one value of the corresponding column B. How can I view all values of B when filtered with A? (Auto filter with merged cells) will work?


    A B
    Cat Val
    21
    22
    a 23
    24
    25

    12
    34
    b 56
    30


    Thankx

  2. #2
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264
    Jessy,

    I think you will find you are out of luck! Auto filter and merging do no go together.

    You need to avoid merging cells if you can - it makes lots of thing difficult or impossible and you can normally get around the need for it other ways.

    Ed

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578
    In any case, filtering works on a row by row basis so if you filter something out in column A row 6, the entire row 6 will be hidden.

    ChemistB

+ 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