![]() Keep the selection status of A2: A15, and then go to Home tab, and click Find & Select > Go To Special, in the Go To Special dialog box, select Blanks option under Select section,see screenshot:Ĥ. Select your original merged cell (A2:A15), and then click Home > Merged & Center to cancel the merged cells, see screenshots:ģ. Copy your merged cells data to other blank column in order to keep the original merged cell formatting.Ģ. To solve this job, you need to do following operations step by step.ġ. In excel, the Filter feature allows you to filter only the first item which associated with the merged cells, in this article, I will talk about how to filter all related data from merged cells in Excel?įilter all related data from merged cells in Excelįilter all related data from merged cells in Excel with Kutools for Excel Supposing there is a column of merged cells in your data range, and now, you need to filter this column with merged cells to show all the rows which are related with each merged cell as following screenshots shown.
0 Comments
Leave a Reply. |