Excel Filter Not Working With Merged Cells? Fix It

If Excel’s filter is missing, disabled, or returning confusing results around merged cells, unmerge the cells in the list—especially in its header row—and give each record its own value in every column you need to filter. Excel filters work on a rectangular range of individual cells; a merged area can obscure the row-by-row structure that filtering and sorting expect.

Why merged cells interfere with filtering

A merged cell is not a set of separate cells that happen to look joined. Excel retains the content in the upper-left cell of the merged area and treats the other cells in that area as empty. That design is convenient for a report title, but it does not describe a normal data column, where each row should have its own value.

For example, imagine a sales list with columns for Region, Rep, and Amount. If the word North is merged vertically across five rows, only the first cell in that merged area contains North. The remaining rows are technically blank in the Region column. A filter cannot reliably interpret that visual block as five records tagged North, because the worksheet does not actually store five separate North values.

Merged cells can also complicate sorting and resizing a filtered range. Excel needs to move or hide whole records consistently. A merged area that crosses rows or columns does not line up with that record structure, so commands may be unavailable, may produce an error, or may give results that look surprising. The filter is not reading the visual appearance; it is reading cell values and the boundaries of the range.

Check whether the problem is the header or the data

Start by identifying exactly where merging occurs. A merged title above the list is usually different from merged cells inside the list. A title in A1:F1 can be merged while the actual headers begin in row 3, provided the filter range starts at the real header row and the list beneath it has ordinary, unmerged cells. By contrast, merging cells in the header row or in the records themselves can interfere with filtering.

Look for these clues before changing the sheet:

The column labels appear centered over two or more columns, and clicking them shows a merged range.
A category name is shown once beside several records because a cell was merged vertically.
Data > Filter is unavailable, or the drop-down arrows do not appear on every intended column.
The filter arrows appear, but filtering a category leaves blank-looking records or hides more rows than expected.
Excel reports that the operation cannot be performed on merged cells when you try to sort or convert the range to a table.

To inspect a suspected cell, select it and check Home > Merge & Center. If the button indicates that the selection is merged, use its drop-down or choose Unmerge Cells. Unmerging does not restore repeated labels automatically: the value remains in the upper-left cell, and the other cells become blank.

Repair the list without losing the information

Make a copy of the worksheet or workbook before restructuring a report you rely on. Then unmerge cells within the filter range and make the data rectangular: one header row, one record per row, and one field per column. Do not merge across a header, record, or group of records that you expect Excel to filter or sort independently.

Select the affected range, or select the merged cells in the list, and choose Home > Merge & Center > Unmerge Cells. Check the surrounding rows and columns because merged areas can extend beyond the cell you first noticed.
Decide what each newly blank cell means. If a blank means the same category as the label above, fill that category down. If it means unknown, not applicable, or genuinely empty, leave it blank or record that meaning explicitly instead.
Check that every column has one clear label in the header row. Avoid blank header cells and avoid putting two labels into one merged header.
Select a cell in the repaired list and choose Data > Filter. Confirm that Excel places a drop-down arrow in each header cell, then test one column before relying on the results.

For repeated group labels, one way to fill only the intended blanks is to select the relevant data cells, choose Home > Find & Select > Go To Special > Blanks, type an equals sign, press the Up Arrow, and press Ctrl+Enter. This places a relative reference to the cell above in each selected blank. Use this only when every selected blank is supposed to repeat the value immediately above it; exclude the first data row if it has no label above. Review the results, then copy the filled cells and use Paste Special > Values if you want fixed text rather than formulas. On a Mac, the Go To Special command is also available through Find & Select where shown; keyboard shortcuts can differ, so use the ribbon path if needed.

Make the header row filter-friendly

Excel’s filter expects a single row of column headings, with one heading per column. Each heading should be nonblank and distinct enough to identify the field. Avoid merged header cells, multi-row headings within the filter range, and completely blank rows or columns splitting the list. Put any decorative title or explanatory notes outside the list, with at least a clear separation from its header and records.

For example, replace a merged heading across B and C called Sales details with separate headings such as Product and Amount. If the worksheet needs grouped labels for presentation, place them above the actual header row, outside the range you filter. When you turn on filtering, select a cell in the data or select the exact range beginning with the real header row, then use Data > Filter. If the selected range is ambiguous, Excel may guess its boundaries, so checking the arrows and the chosen range is worthwhile.

A formatted Excel table can help keep a list structured. Select the unmerged range, choose Insert > Table, confirm that the range includes headers, and select My table has headers when appropriate. Tables provide filter arrows in their header row and generally expand as adjacent records are added. They do not make merged cells inside the table suitable; unmerge and normalize the data first. If the table option is unavailable or reports a merged-cell issue, inspect the proposed range for merges and irregular layout.

Keep a polished layout without merging data

Unmerging does not mean a worksheet must look plain. Keep the data area structured and use formatting around it instead. For a heading that should appear centered across several columns, select those cells, open Format Cells with Ctrl+1, go to the Alignment tab, and choose Center Across Selection from the Horizontal list. This aligns the text across the selected cells without combining them into one merged cell. It is a formatting choice, not a replacement for separate column headings.

Other presentation options include applying a fill color to a group of columns, using borders to show sections, or putting a report title on its own row above the table. For repeated categories, repeating the category name in each record is often the most useful choice. It may look less compact than a vertically merged label, but it makes filtering, sorting, copying, and importing the records much more predictable.

When a report must preserve a merged layout for printing, consider separating the presentation sheet from the source data. Keep one normalized list as the source for filters and analysis, then create a report view with the desired visual formatting. This avoids repeatedly unmerging and rebuilding the same data and reduces the risk that someone edits a visually blank cell without understanding that it represents a category.

Common filter problems that are not caused by merging

If the data is unmerged and filtering still seems wrong, check the range and the values themselves. A completely blank row can make Excel treat records below it as a separate block. Blank cells in a field may appear under a (Blanks) entry in the filter menu; that is normal and does not necessarily indicate a broken filter. Spaces, inconsistent spelling, and numbers stored as text can also split what a reader thinks should be one category into several filter choices.

Confirm that the filter range includes all records and exactly one header row. If only part of the list has arrows, turn the filter off and select the full range before turning it on again.
Check for hidden rows, hidden columns, or an existing filter condition. Choose Data > Clear to clear filter criteria without deleting the underlying records, then inspect the list again.
Check whether the worksheet is protected. Protection settings can restrict filtering, depending on how the sheet was protected.
Look for merged cells elsewhere in the selected range, including merges that are not obvious because the cells have matching fills or borders.
Check for duplicate or blank headings and for a second header row mistakenly included as data.

Filtering hides rows that do not match; it does not delete them. If a filter appears to remove records, clear the criteria and inspect the full list before concluding that data was lost. Similarly, sorting is a separate operation: unmerged cells are important for reliable sorting, but a filter arrow by itself does not rearrange records.

Alternatives when the merged appearance is required

If you need to show a category once beside a group of records, you can keep the source list unmerged and create a separate display area. Another simple option is to repeat the category in each row and use borders or shading to make groups visually obvious. These approaches preserve the row-level value that a filter needs.

For a one-off report that cannot be redesigned, work on a copy: unmerge the relevant cells, fill the category values down where appropriate, apply the filter, and avoid saving over a presentation version until you have checked the result. This is a workaround, not a way to make merged cells behave as independent values. If another system will consume the data, such as a database or a CSV export, the unmerged, repeated-value structure is usually the safer source format.

Excel for Microsoft 365 on Windows uses Data > Filter on the ribbon; Excel for Mac and Excel for the web provide filtering controls too, though the ribbon layout and some keyboard shortcuts vary. The underlying issue is the same: merged display areas do not supply a separate value for every row. If a workbook is shared across versions or platforms, a plain rectangular list is also easier for other spreadsheet tools to interpret.

Frequently Asked Questions

Can Excel filter a range that contains merged cells?
It may allow a filter in some layouts, particularly when the merges are outside the actual list, but merged cells inside the header or records can cause missing arrows, restrictions, or misleading results. Unmerge cells within the data range and store a value in each record that needs to be filtered.

Why does the filter show (Blanks) after I unmerge cells?
Unmerging keeps the value only in the upper-left cell of each merged area. The other cells become blank, so the filter correctly lists blanks. Fill those cells with the intended repeated value if they represent the same category, or leave them blank if that is what the data means.

Can I merge cells in a title above a filtered list?
Usually, yes, if the title is outside the range being filtered and the actual list has a separate, unmerged header row. Start the filter at the real header row rather than including a decorative title row as part of the data range.

Why can’t I convert my filtered range to an Excel table?
Tables require a consistent rectangular range with a header row, and merged cells in the proposed range are incompatible with that structure. Unmerge the range, ensure every column has a heading, and try Insert > Table again.

Will unmerging cells delete my labels?
Unmerging does not usually delete the value in the upper-left cell, but it does not copy that value into the other cells. Those cells become blank. Make a backup and verify which blanks should be filled before using the range for filtering.

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.