Yes—when a cell is merged vertically across several rows, Excel stores its value only in the top-left cell, so a filter does not treat every row in the merged block as having that value. To make all related records filter together, unmerge the cells and repeat the category or label on every row.
Why a merged cell shows only one row
Excel filters records row by row. For each row, it checks the value in the column being filtered and decides whether that row meets the filter criteria. A vertically merged cell looks as though it contains a label across multiple rows, but the label is stored only in the cell at the upper-left corner of the merged area. The remaining cells in that area have no independent values.
For example, imagine the word Hardware appears in a cell merged across rows 2 through 4, beside three product records. The sheet may look as if Hardware labels all three records. To Excel, however, the value is in A2; A3 and A4 are not separate cells containing Hardware. A filter for Hardware therefore cannot reliably identify all three rows as matching records. The apparent label and the underlying data are different.
This is not a setting that tells Excel to extend a value down through the merged area. Nor does filtering interpret the visual height of a cell as a group of related records. It uses the values that actually exist in the cells of each row.
What happens when you apply AutoFilter
In Excel for Microsoft 365 on Windows, you can place the active cell in a regular data range and choose Data > Filter. Excel adds a dropdown to each column header. When you select a value from a dropdown, Excel hides rows that do not meet the selection. It does not rewrite the data or fill in blanks automatically.
With vertically merged labels, that row-by-row process can produce a confusing result. The matching label may be in the first row of a group while the rows below have blank cells in the filtered column. Depending on the layout and which rows are hidden, the merged area can also look awkward or incomplete. The key point is that the filter is not treating the merged block as one multirow record; it is evaluating separate worksheet rows.
A horizontal merge is different: it joins cells across columns in the same row, rather than visually grouping several records down a column. It can still make a data layout harder to sort or filter, especially if it overlaps headers or fields, but the specific first-row symptom usually involves vertical merging in a column that is meant to hold a value for every record.
Fix the source data by repeating each label
The most dependable fix is to make every record row complete: unmerge the label cells and put the category in each row that belongs to that category. This is the format filters, sorts, PivotTables, and other data tools expect. Before changing a shared or important workbook, save a copy so you can restore the original presentation if needed.
- Select the merged cells or the full affected column.
- On the Home tab, open the Merge & Center dropdown and choose Unmerge Cells. The value remains in the upper-left cell; the newly separate cells below it are blank.
- Enter the appropriate label in each blank record row. For a short list, typing or copying the label down is straightforward.
- Apply the filter again using Data > Filter, then choose a category from the column dropdown and confirm that all intended records remain visible.
Do not fill down through rows that are genuinely separate groups or meant to stay blank. The repeated values should represent the records, not merely make the sheet look fuller. If the dataset is large, a helper column can carry the label down without changing the original column immediately.
Use a helper column for a large grouped list
Suppose column A contains category labels in merged blocks, and rows 2 through 7 are records. After unmerging A2:A7, assume A2 contains Hardware, A3:A4 are blank, A5 contains Software, and A6:A7 are blank. Put a heading such as Filter category in B1. With that layout, enter the following in B2 and fill it down through B7:
=IF(A2="",B1,A2)
The formula takes the category from column A when one is present; otherwise it carries forward the result from the preceding row in column B. For the example, B2:B4 will show Hardware and B5:B7 will show Software. Filter on column B instead of the merged source column. This result assumes that each new group begins with a label and that blank cells in A mean continuation of the previous group. If blanks have another meaning in your data, review them rather than automatically carrying labels forward.
When the helper results are correct, you can leave the formula column in place, or copy it and use Paste Special > Values to make fixed labels. If you replace the original category column, verify the results before removing the helper. The helper approach is especially useful when you need to preserve the original appearance temporarily while creating a usable filtering field.
Why merged cells cause trouble beyond filtering
Merged cells are primarily a formatting convenience, not a good way to represent relationships between records. They can obstruct ordinary spreadsheet operations because a merged area does not give every row a separate value. Sorting is a common example: Excel may refuse to sort a range when merged cells do not have matching dimensions, or the layout may not sort in the way a user expects. Filtering and sorting both work best when each row is a complete record and each column holds one type of information.
Merged cells can also cause problems when you turn a range into an Excel table. A table is designed around a single, unmerged header cell for each column and a consistent set of rows. Unmerge cells and make sure the header row has one heading per column before choosing Insert > Table or Home > Format as Table. Repeating category values also makes later analysis easier: for instance, a PivotTable can group records by a category column when each record actually contains a category value.
Another misconception is that blank cells are automatically treated as belonging to the most recent nonblank label. That may be a reasonable interpretation for a person reading a report, but Excel’s filter does not infer that relationship. Blank is a separate cell state, not an instruction to copy the preceding value.
Keep the grouped appearance without merging
If the reason for merging is to make repeated categories look like one heading beside a group, retain the repeated values in the data and change only how they are displayed. One option is to leave the category repeated on every row and use borders, indentation, or shading to distinguish groups. Another is to create a separate presentation sheet for printing while keeping the source data in a flat, filterable layout.
For a centered heading spanning columns, use alignment rather than merging when practical. Select the cells across which the heading should appear, open the Format Cells dialog, choose the Alignment tab, and set Horizontal to Center Across Selection. This changes the appearance without combining the cells. It is intended for horizontal presentation across a row; it does not replace the need to repeat category labels down the rows of a data list.
On Excel for Mac, the same underlying rule applies: a merged area stores its content in its upper-left cell. The ribbon arrangement can differ slightly by release, but use the Home tab’s merge controls to unmerge, then repeat the values or use a helper column. Excel for the web also has merge controls and filtering, but the data-structure solution is the same. If a particular workbook’s ribbon differs, search Excel’s command box for Unmerge Cells or Filter.
Check the range if filtering still looks wrong
After fixing merged values, check the filter setup as well. A filter applies to a contiguous range with a clear header row. Extra title rows, blank rows inside the dataset, or headers that span several columns can cause Excel to choose the wrong range or interpret headers unexpectedly. Select the actual header and records before choosing Data > Filter, and confirm that each field has its own heading.
- Check that the category column contains a value on every record row that should match.
- Make sure the filter range includes all the relevant records but not unrelated notes or a second table.
- Look for hidden rows or other active filters that may make some records seem to have vanished.
- Clear the filter and reapply it after editing the source values; verify the selected items in the dropdown.
- Check that the label is not only in a merged header or decorative cell outside the actual data range.
If only the first row appears even after unmerging, inspect the formerly merged cells. Unmerging preserves the top-left value but does not fill the blanks underneath it. That is why simply choosing Unmerge Cells is not the whole repair: the category has to be copied or otherwise supplied to every record that belongs to it.
Frequently Asked Questions
Can Excel filter all rows covered by one merged cell?
No. A vertical merge does not store the same value separately in every covered row. Unmerge the area and repeat the label on each record, or use a helper column that carries the label down.
Will unmerging fill the value into the blank cells?
No. Excel keeps the existing value in the upper-left cell and leaves the other cells empty. You need to fill or calculate the missing labels after unmerging.
Why does the merged label seem to disappear when I filter?
Filtering hides rows that do not match. If the row containing the stored value is hidden, or if the visible rows have blank cells in that column, the merged label can appear to vanish or become visually confusing. Check the underlying values and filter selections.
Can I use merged cells in an Excel table?
Merged cells are not suitable within a structured Excel table. Unmerge the cells and give each column a single header and each record row its own values before converting the range to a table.
Is Center Across Selection a filter fix?
Not by itself. It can provide a centered appearance for a heading across columns without merging those cells. For category labels that apply to multiple records down the sheet, repeat the value in every row so the filter can evaluate each record correctly.
Related
- Excel Data Validation List Auto Update: How to Set It Up
- Excel Data Validation Lists: Add New Items in Excel
- Excel Data Bars: How to Add, Format, and Troubleshoot
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- VLOOKUP in Excel for Multiple Columns: Methods and TipsYes. In Excel for Microsoft 365, VLOOKUP can return values from multiple columns either by copying one formula…
- Excel MAX IF: Find the Highest Number by ConditionTo find the largest number in Excel that meets a condition, use MAXIFS, such as =MAXIFS(C2:C7,B2:B7,"East"). If you…
- SUMIFS in Excel: Sum Values by Multiple Criteria ExplainedSUMIFS in Excel adds values only when they meet one or more conditions. For example, with sales in…
- Text Split in Excel: Methods, Formulas, and Common FixesTo split text in Excel, select the cells and choose Data > Text to Columns to separate values…
- Excel Formula for Workdays Between Two DatesTo count workdays between two dates in Excel, use =NETWORKDAYS(A2,B2), where A2 contains the start date and B2…
- How to Sort an Excel PivotTable Largest to SmallestTo sort an Excel PivotTable from largest to smallest, right-click a number in the value column you want…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.