Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Want help to filter merge cell in Microsoft Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 24-02-2012
Member
 
Join Date: Feb 2012
Posts: 9
Want help to filter merge cell in Microsoft Excel

I am using Excel 2003. I want to be able to filter merged cells (that are in one column, covering several rows) so that all the data associated with the merged cell appears and not just the top line. e.g. set up a table with two columns and an auto filter at the top. In the left column put certain categories of data, for example say food types e.g. fruit or meat, and then in the right column the actual food, so for fruit you could have apples, bananas and pears. Now for presentation purposes I want to have the left column merged so that the food category appears once vertically centered in the middle of the rows, but I want to be able to filter this column to pick up all the data i.e. if I filter for fruit I want to get apples, bananas and pears not just apples.

Reply With Quote
  #2  
Old 24-02-2012
Member
 
Join Date: May 2011
Posts: 446
Re: Want help to filter merge cell in Microsoft Excel

You could try grouping your data. First, go to Data/Group and Outline/Setting and uncheck Summary rows below detail and Summary columns to right of detail. Let's say for example your data looks like
A B
1 Apple
2 Fruit Oranges
3 Pears
Select rows 2 and 3. Then click Data/Group and Outline/Group (do this for all of your groups). When you filter for Fruit, you will initially see Fruit in Col A and Apple in Col B, but you can expand the group (by clicking the + sign on the left side of the screen) and should see the rest of the group. Not a one step solution, but the only other thing I can think of is to put a helper column to the right of your data (Column C) and enter "Fruit" in C1:C3 and change the font to white (so it does not appear on screen or print) and filter on this column.
Reply With Quote
  #3  
Old 24-02-2012
Member
 
Join Date: Jun 2011
Posts: 798
Re: Want help to filter merge cell in Microsoft Excel

I will recommend you to read under F1 in excel about filter cell process in detail. In that you can find a number of references.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Want help to filter merge cell in Microsoft Excel"
Thread Thread Starter Forum Replies Last Post
Want help to filter zip codes to ranges in Microsoft Excel Abélard MS Office Support 2 24-02-2012 12:46 PM
How to sort report filter values of Pivot Table in Microsoft Excel Lakshaki MS Office Support 2 24-01-2012 01:07 PM
How to Merge Cells vertically in Microsoft Excel without loosing the Data Eas!war Windows Software 3 11-01-2012 04:59 PM
Partial matching of cell in Microsoft Excel KANAN14 Windows Software 3 04-12-2009 01:20 AM
Short cut to merge cells in Microsoft Excel Jesus2 Windows Software 3 24-11-2009 05:31 AM


All times are GMT +5.5. The time now is 08:41 PM.