Excel Merged Cells Not Showing in Filter? Fix the Data

Excel filters do not treat a vertically merged cell as though its value were repeated in every row: the value exists only in the merged area’s upper-left cell, and the remaining rows are effectively blank for filtering. To make every related record appear under the same filter value, unmerge the data cells and fill the value down; keep merged cells, if needed, out of the filterable data range.

Why merged cells cause filter problems

An Excel filter evaluates the values stored in individual cells in a column. A merged area may look like one label spanning several rows, but Excel stores its content in just one cell: the upper-left cell of the merged area. The other cells in that area do not contain repeated copies of the label. They are blank for purposes such as filtering and sorting.

For example, imagine a report with the category “Fruit” merged across rows 2 through 4, followed by three product records: Apples, Pears, and Plums. The worksheet visually suggests that all three products have the category Fruit. But the category column contains Fruit in row 2 and blanks in rows 3 and 4. Filtering that column for Fruit can therefore show only the row with the stored value, not every row covered by the merged display.

Merging cells across columns can cause a related problem. A merged heading spanning columns A and B has its value only in A; B is blank. If that merged heading is inside the data range, the filter cannot interpret it as two ordinary field names. A clean, unmerged header row and one record per row are much more reliable.

Check whether the filter range includes the right cells

Before changing the layout, confirm that the filter is applied to the complete list. Click a cell in the data and choose Data > Filter on the ribbon. In Excel for Microsoft 365 on Windows, filter arrows should appear on the header cells. If they appear partway down the sheet, or a data column has no arrow, the selected range may not include the intended header or records.

Check these common range issues:

Blank rows or columns split the list. A completely blank row between two parts of a list can make Excel treat them as separate regions. Remove unnecessary gaps or select the whole range before turning on Filter.
The header row is not included. Select the header and all records, then choose Data > Filter. Use one clear header per column.
The filter is already active on another range. Choose Data > Filter to turn the existing filter off, select the intended range, and turn it back on.
The column’s filter includes blanks. Open its dropdown and check whether (Blanks) is selected. If it is, Excel is correctly including empty cells; it is not treating them as the merged label.

A range problem and a merged-cell problem can coexist. Fixing the range will not fill the blank cells created by a vertical merge, so inspect the actual cell values as well as the dropdown arrows.

Unmerge cells and fill values down

For a list where each row represents a separate record, the usual repair is to unmerge the cells and repeat the category or group label in each relevant row. Work on a copy if the existing layout is important: unmerging changes the appearance, and unmerging alone does not populate the newly exposed blank cells.

Select the merged cells in the data column. If you are unsure which cells are merged, select the relevant range and inspect Home > Merge & Center. The command’s highlighted state can help identify merged cells.
Choose Home > Merge & Center > Unmerge Cells. The stored value remains in the upper-left cell of each former merged area; the other cells become blank.
For each group, copy the label into the blank rows that belong to that group. For a short list, typing or copying the label into the blanks is simple and easy to verify.
Reapply the filter using Data > Filter, then choose the category in the dropdown. All records with that repeated value can now be included.

For a long list with many merged groups, you can fill blanks in a controlled selection. First unmerge the cells, then select only the range containing the category values. Use Home > Find & Select > Go To Special > Blanks to select blank cells in that selection. Enter a reference to the cell immediately above the active blank, then press Ctrl+Enter on Windows to put the formula into the selected blanks. Check the results carefully, then copy the repaired range and use Home > Paste > Paste Values if you want fixed text rather than formulas. Because this operation affects every selected blank, do not use it across unrelated gaps or missing data that should remain blank.

Keep merged titles out of the filterable list

A merged title can be useful for presentation, but it should sit above the actual table rather than inside its header or records. For example, place a merged report title in row 1, use ordinary unmerged headers in row 3, and begin records in row 4. Select the header row and records for the filter range; do not include the decorative title row as a field header.

For a more structured list, select the unmerged range and choose Insert > Table. Confirm that My table has headers is selected when appropriate. Excel tables provide filter arrows in their headers and automatically expand as records are added. The table should have one header per column, no merged cells in its records, and no blank header names. A merged heading can remain outside the table for visual design.

Tables are especially helpful when the list grows or when formulas and formatting need to extend to new rows. They do not change the basic rule: each record needs its own value in any field you intend to filter reliably.

Filtering, sorting, and merged cells are not the same issue

Filtering hides rows that do not meet a condition; it does not repair or reinterpret the underlying data. If a label appears visually beside several records because it is merged, filtering still sees the value in its one stored cell and blanks in the others. Choosing a different filter setting cannot make those blanks inherit the label.

Sorting is also risky with merged cells in a data range. Excel may refuse to sort a selection containing merged cells of different sizes, or the result may not preserve the relationship you intended between fields. A reliable sortable list has a consistent row structure: one record per row, one field per column, and no merged cells within the records. Unmerge and fill down before sorting, not after, so each row carries the values needed to stay associated with its other fields.

There is an important distinction between an intentional blank and a missing value. If a blank means “same category as the row above,” filling it down is appropriate. If it means “unknown,” “not applicable,” or “not yet entered,” replacing it with the previous row’s value would misrepresent the data. Decide what the blank means before applying a bulk repair.

Alternatives when you want the merged appearance

If the goal is a centered heading rather than a label that spans records, use a layout option that does not merge the cells. Select the cells and open Home > Alignment using the dialog launcher, then choose Center Across Selection from the horizontal alignment options where available. This centers text across the selected cells without combining them into a merged cell. It is suitable for a visual heading, not a substitute for repeating a category value in every data row.

Another option is to keep the data on one worksheet in a flat, filter-friendly structure and create a separate presentation sheet with merged headings or grouped labels. This preserves the readable report while keeping the source list suitable for filtering, sorting, PivotTables, and other analysis. If you receive a merged-cell report from someone else, consider keeping an unchanged copy and doing the cleanup in a separate working range.

What to do if the filter still misses records

After unmerging and filling down, check the data itself rather than relying only on the worksheet’s appearance. Click several affected cells and look at the formula bar. Each record that should match needs its own category value. A cell that looks blank may contain a space or a formula returning an empty string; such entries can behave differently from truly empty cells and may appear as separate items in a filter dropdown.

Also check for inconsistent text, such as “Fruit” in some rows and “Fruit ” with a trailing space in others. These are not the same stored text. Correct the inconsistent values, confirm that the filter range still covers all records, and reopen the dropdown. If the list has changed substantially, turn Filter off and on again for the intended range. In Excel for the web and Excel for Mac, the ribbon labels and dialog placement can differ slightly, but the core repair is the same: unmerge data cells, put a real value in each applicable record row, and filter the complete range.

Do not use “Select All” as a substitute for diagnosing the issue. If selecting a visible category still leaves expected rows hidden, first determine whether the rows contain that value, contain blanks, or fall outside the filtered range. That check identifies whether the cause is the merged layout, the filter selection, or inconsistent source data.

Frequently Asked Questions

Can Excel filter merged cells?

Excel can apply a filter to a range that contains merged cells, but it does not repeat a merged cell’s value across the rows it spans. Only the upper-left cell stores the value, so filtering the column may leave the other rows out when you select that value.

Why does a merged category appear only once in the filter list?

The category is stored in one cell, not once per row. The remaining cells in the merged area are blank, so the filter list reflects the stored value and may also offer a blanks option.

How do I unmerge cells without losing the label?

Select the merged area and choose Home > Merge & Center > Unmerge Cells. Excel retains the value in the former area’s upper-left cell. The other cells will be blank, so fill them with the appropriate value if those rows represent records in the same category.

Can I keep merged cells in a report and still filter the data?

Yes. Keep merged titles or decorative headings outside the filter range, and use an unmerged header row and unmerged records for the list. You can also maintain a flat data sheet for filtering and a separate formatted sheet for presentation.

Should I fill every blank cell with the value above it?

No. Fill down only when the blank means that the row belongs to the same group as the preceding labeled row. Leave genuine unknown or not-applicable values blank, or mark them explicitly according to the data’s meaning.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.