Ad Free CAclubindia and Daily Updates on your Mobile. Subscribe Now!

Filtering merged cell in excel

CA Ankit Banka (CA) (183 Points)

11 December 2013

Hi..,

I Need to Filter Columns Of Merged Cells so that all related rows can be viewed. Is this possible..

Thanks in advance

Ankit

Reply
Follow
Share

10 Replies

Ashok (Industry) (416 Points)
Replied 11 December 2013

Not possible to filter merged cells. Unmerge it do it.

Upgrade to CAclubindia Pro. Subscribe Now!

Shruthi (Article Assistent) (336 Points)
Replied 11 December 2013

Instead you can remove merge & try the below

Select the cells which you want to merge

Go to format cells-->Alignment-->Horizontal--> Select option Center across selection.

This serves the same purpose of merge cells but without above limitation.

1 Like

Ashok (Industry) (416 Points)
Replied 11 December 2013

very good technique shruthi

1 Like

NOUFAL (ACCOUNTANT) (762 Points)
Replied 11 December 2013

I cant understand your problem. Please sent the attached file. I will give the answer.... if i can..

CA Ankit Banka (CA) (183 Points)
Replied 12 December 2013

Hi Naoufal..

Attached please find the sample file.

Thanks

Ankit

Attached File : 193849 1260067 sample file.xlsx downloaded: 455 times

Upgrade to CAclubindia Pro. Subscribe Now!

NOUFAL (ACCOUNTANT) (762 Points)
Replied 12 December 2013

thanks for the file.

Am really sorry. i dont have any idea for filtering. If your data is small. You can fill color in merged cell. ans filter by color

CA Ankit Banka (CA) (183 Points)
Replied 14 December 2013

Thanks for your time..anyway I got solution for my problem.

NOUFAL (ACCOUNTANT) (762 Points)
Replied 16 December 2013

will you please publish the solution...

CA Ankit Banka (CA) (183 Points)
Replied 16 December 2013

Here what I tried is that I inserted one coloumn before the coloumn in which the merged datas are. Then applied the formula "=IF(B2="",A1,B2)" and copied it till the end and merged the heading of the new coloumn and the other one. Now all the corresponding rows to the merged cell can be viewed. Sample file of the same is attached herewith for your kind reference.

Attached File : 193849 1261335 sample file.xlsx downloaded: 904 times

1 Like