Yes. In Excel, select the empty cells you want to combine, then choose Home > Merge & Center and the merge option you need. If every selected cell is empty, Excel creates one larger blank cell; if any cell contains data, Excel keeps only the value in the upper-left cell and discards content from the others.
What merging empty cells means in Excel
Merging combines a rectangular group of neighboring cells into one larger cell. The merged area still occupies the same rows and columns visually, but Excel treats it as a single cell for many editing tasks. Its reference is the address of the group’s upper-left cell. For example, merging B2:D2 produces one cell whose address is B2.
When all cells in the selection are truly empty, there is no content to lose. The result remains blank, so merging can be useful for creating a wide space for a heading, note, or label. You can type into the merged cell afterward; the entry belongs to its upper-left address.
“Empty” can mean different things in a spreadsheet. A cell may look blank but contain a space, an apostrophe, or a formula that displays an empty string. Such a cell is not necessarily empty to Excel. If the selected range contains content, Excel may show a warning that merging keeps only the upper-left value. Check the cells before confirming, especially in a workbook you did not create.
How to merge blank cells on Windows
For a single horizontal or vertical block of blank cells in Excel for Microsoft 365 on Windows:
- Select the adjacent rectangular range, such as B2:D2 or A4:A6. You can drag across it or select the range using the Name Box to the left of the formula bar.
- Open the Home tab on the ribbon.
- Open the arrow beside Merge & Center in the Alignment group.
- Choose Merge Cells if you want one merged cell without centering its contents. Choose Merge & Center if the result should also center text horizontally.
If all selected cells are blank, the result is a blank merged cell. If Excel displays a warning about keeping only the upper-left value, pause and inspect the range rather than clicking through automatically. To undo a merge immediately, use Ctrl+Z. Once other edits have been made, choose Home > Merge & Center > Unmerge Cells instead.
On Excel for Mac, the merge choices are also on the Home tab, though the ribbon layout can differ. In Excel for the web, look on the Home tab for the merge control; available options and their presentation can vary with the web interface. Merging is a formatting and layout action, not a way to combine values.
Which merge option should you choose?
The dropdown includes options that behave differently. The right choice depends on whether you want one large cell or just a visual heading across several columns.
- Merge & Center merges the selection and centers its content. This is often used for a title above a small report.
- Merge Cells merges the selection without applying the horizontal centering that comes with Merge & Center.
- Merge Across creates separate merged cells across each row of the selected range. For example, selecting B2:D4 and using Merge Across creates one merged cell for B2:D2, another for B3:D3, and another for B4:D4; it does not make one large cell across all three rows.
- Unmerge Cells returns a merged area to separate cells. The content remains in the upper-left cell; unmerging does not restore values that were discarded during the original merge.
If you select a larger range than intended, Excel may merge more rows or columns than you expect. Check the selection outline before choosing a command. For a simple heading across one row, select only that row’s cells rather than an entire block of the worksheet.
How to avoid losing data
Excel’s main merge limitation is important: when multiple selected cells contain entries, only the upper-left cell’s content is retained. That content could be text, a number, or a formula. Data in the other cells is removed from the merged result. A warning is not a data-combining feature; accepting it does not join the values together.
Before merging a range that might contain information, inspect every cell and keep a copy of anything you need. You could copy the values to another area or duplicate the worksheet first. If the goal is to join text from several cells, combine the text using an appropriate formula or the data tools instead, then place the finished result in a single cell. Merging is not a substitute for concatenating data.
Also check for formulas and invisible-looking content. A formula can return an empty-looking result while still being present, and a cell containing a space may appear blank. If you need to distinguish genuinely empty cells from cells that only look empty, inspect the formula bar or use Excel’s blank-cell selection tools before merging. Do not assume a white-looking area has no content.
Alternatives that keep cells separate
Merged cells can make a worksheet harder to sort, filter, select, paste into, or use as a source for formulas and tables. If you mainly want a heading to look centered across several columns, use Center Across Selection instead. This centers the text across the selected cells visually while leaving the cells separate, so the grid remains easier to work with.
To apply it, select the cells, open the Format Cells dialog, choose the Alignment tab, and set Horizontal to Center Across Selection. On Windows, open Format Cells with Ctrl+1; on Mac, use Command+1. The cells remain distinct, and the heading should be entered in the leftmost cell of the selection. This option is useful for report titles, but it does not create one large editable cell.
Other alternatives may fit different needs:
- Wrap Text: Keep a label in one cell but display it on multiple lines. Find it on the Home tab in the Alignment group.
- Adjust column width or row height: Make room for a title without changing the worksheet’s cell structure.
- Use borders and fill: Apply formatting across separate cells to create the appearance of a single heading area while preserving the grid beneath it.
- Put the label in one cell: If the surrounding cells are blank, a wider column or suitable alignment may solve the layout problem without merging.
These approaches are especially helpful when the worksheet will be sorted or filtered later. A visually continuous heading does not always need to be a merged cell.
Common problems and limitations
Merge Cells is unavailable or disabled. One common reason is that the selection is inside an Excel table. Tables have a structured grid and do not allow merged cells within the table area. If merging is genuinely necessary, use Table Design > Convert to Range first, understanding that the data will no longer have table behavior. Often it is better to leave the data as a table and put a heading above it.
Sorting or filtering behaves oddly. Merged cells create uneven cell shapes, which can conflict with operations that expect each row to have a consistent structure. Unmerge the relevant areas before sorting or filtering a data list, and keep column headers in individual cells. A clean rectangular data range is more reliable for analysis.
Pasting into a merged area fails. The copied range and destination may not have matching dimensions or merge patterns. Unmerge the destination, paste into ordinary cells, and apply any needed visual formatting afterward. The same issue can arise when filling a range or selecting cells with the keyboard.
The result is still blank. That is expected if the selected cells were blank: merging changes the shape of the cell, not its value. If you meant to fill blank cells with a label or copy values into them, that is a separate task. Enter the desired content after merging, or use a fill method that preserves the individual cells if the blanks are part of a data table.
When merging is appropriate
Merging is most suitable for presentation areas that are not part of a data table, such as a report title above a worksheet or a decorative label spanning a few columns. If the merged cell will contain only one short heading and the surrounding range is not needed for sorting, filtering, or data entry, merging blank cells is usually straightforward.
Avoid merging within the body of a list where each row represents a record. For example, a sales table with one row per order should keep each field in its own cell, even if several adjacent cells are blank. Merged cells can interrupt the consistent row-and-column layout that Excel features rely on. For shared workbooks, it is also worth considering whether others will copy, import, or analyze the data later.
Frequently Asked Questions
Can I merge cells in Excel if they are all blank?
Yes. Select the adjacent cells and choose a merge option from Home > Merge & Center. Excel creates a blank merged cell. You can enter text or a value in it afterward.
Does Excel merge the contents of cells automatically?
No. When a selected range contains more than one entry, Excel keeps the upper-left entry and removes the others from the merged result. To retain multiple values, combine them separately before merging or use an alternative that leaves cells separate.
Can I merge nonadjacent empty cells?
No. A merge selection must be a contiguous rectangular range. To create separate merged areas, select and merge each adjacent block separately.
How do I unmerge cells without losing the value?
Choose Home > Merge & Center > Unmerge Cells. The existing content stays in the upper-left cell of the former merged area; the other cells become separate and blank. Unmerge cannot recover content removed when the cells were first combined.
What should I use instead of merging a report heading?
For a heading that only needs to appear centered across columns, use Center Across Selection in Format Cells > Alignment. It preserves separate cells, which is generally friendlier to sorting, filtering, and later editing.
Related
- Excel Shortcut to Hide a Column on Windows and Mac
- Excel: Hide Row and Column Numbers from the Worksheet View
- Excel Hide Specific Columns: Steps and Tips
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Formula for Not an Error: ISERROR ExplainedTo check whether a cell does not contain an Excel error, use =NOT(ISERROR(A2)), replacing A2 with the cell…
- Excel Showing Formulas Instead of Results? Fix ItIf Excel shows formulas in cells instead of their calculated results, first turn off Formulas > Show Formulas.…
- Excel Shortcut Not Working? Find and Fix the CauseIf an Excel shortcut is not working, first check that Excel has focus, that you are pressing the…
- Excel Double-Click Column Width Not Working?If double-clicking an Excel column boundary does not resize the column, first double-click the right edge of its…
- Excel All Cells Must Be the Same Size Error ExplainedThe Excel message “To do this, all the merged cells need to be the same size” usually means…
- Excel Not Incrementing Cells When Dragged? How to FixIf Excel is not incrementing cells when you drag, it may be copying the selected value instead of…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.