Filtering merged cell in excel

Hi..,

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

Thanks in advance

Ankit

Replies (10)

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

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.

very good technique shruthi

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

Hi Naoufal..

Attached please find the sample file.

Thanks

Ankit

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

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

will you please publish the solution...

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.

good idea....

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
20 November 2026
Charted Accountant

Cothas Coffee Co.

Bengaluru

CA

View Details