Merging cells combines two or more cells into one larger cell

When you merge cells in Excel, you are combining adjacent cells so they act as a single cell. The merged cell spans across the rows or columns you selected. Excel keeps the content from the top-left cell and discards the rest, so you lose data if the other cells contained information.

Merging is useful for headers that span multiple columns, titles that sit above a data table, or labels that need to stretch across a section. It is not useful for data you plan to sort, filter, or analyze — merged cells break those features. If you are building a spreadsheet to actually work with numbers or lists, avoid merging. If you are building a layout or a printed report, merging can make it clearer.

Key Takeaways

  • Select the cells you want to merge, then use the Merge & Center button on the Home tab or right-click and choose Merge Cells.
  • Merging deletes all content except what was in the top-left cell, so check that the other cells are empty before you merge.
  • Merged cells prevent sorting, filtering, and many formulas from working correctly, so use them only for headers and labels, not data.
  • You can unmerge cells at any time by selecting the merged cell and clicking Unmerge Cells on the Home tab.

How to merge cells step by step

Open your spreadsheet and select the cells you want to combine. Click and drag from the first cell to the last cell, or click the first cell, hold Shift, and click the last cell. All selected cells should be highlighted in blue.

Go to the Home tab at the top of the ribbon. Look for the Merge & Center button — it shows two cells joining together. Click the small arrow next to it to see your options: Merge & Center (centers the text), Merge Across (merges left to right on the same row), or Merge Cells (merges without centering). Choose the one that fits what you need.

Excel will merge the cells when ready. If the cells you merged contained data other than the top-left cell, Excel shows a warning that it will delete that content. Click OK to confirm. The merged cell now spans the space of all the cells you selected.

What happens to your data when you merge

Excel keeps only the content from the top-left cell in your selection. Everything in the other cells disappears. For example, if you merge cells A1 through D1, and A1 contains "Sales" while B1 contains "2024", the merged cell will show only "Sales" and "2024" is gone.

This is why you should always check that the cells you are merging are either empty or contain only the text you want to keep. If you accidentally merge cells with data you needed, press Ctrl+Z when ready to undo and get your data back.

Why merged cells break sorting and filtering

When you sort or filter a spreadsheet, Excel looks at the structure of your data — it expects each column to have a header in the first row, then data rows below. A merged cell confuses that structure. If your header row has a merged cell, Excel may not recognize where one column ends and another begins, and sorting or filtering may not work at all or may produce wrong results.

The same problem happens with formulas. If you try to reference a merged cell in a formula, or if a formula tries to count or sum across a merged cell, the result may be incorrect or the formula may return an error. For this reason, never merge cells that contain data you plan to analyze or sort.

Better alternatives to merging for headers and titles

If you need a title that spans your entire table, you can put it in a single cell above the table instead of merging. Make that cell wider by adjusting the column width, or just let the text overflow into the empty cells below. The text will display across multiple columns without actually merging, and your data structure stays intact.

For headers, use a single row with one header per column — no merging. If you want a group header that covers multiple columns (like "Q1 Sales" covering columns for January, February, and March), put the group header in a row above your column headers, but still use one cell per column. You can format the cells to look grouped by using borders or background color instead of merging.

These approaches give you the visual result you want without breaking your spreadsheet's ability to sort, filter, and calculate.

How to unmerge cells you no longer need

Click on the merged cell to select it. Go to the Home tab and click the arrow next to Merge & Center. Select Unmerge Cells. The merged cell splits back into its original separate cells. The content stays in the top-left cell, and the other cells become empty.

You can unmerge at any point, even if you merged cells weeks ago. There is no limit to how many times you can merge and unmerge the same cells.

Merged cells in printed reports versus working spreadsheets

Merged cells work fine in a spreadsheet you plan to print as a report or share as a static document. A title merged across the top, section headers merged down the left side, and a formatted layout all look professional on paper and in a PDF. The problem only appears when you need to actually use the spreadsheet — sort it, filter it, add formulas, or hand it to someone else to analyze.

If you are building a working spreadsheet that you or others will use to manage data, avoid merging. If you are building a one-time report or a template for printing, merging is fine. Know which one you are building before you start formatting.

Frequently Asked Questions

Can I merge cells that already have data in them?

Yes, but Excel will delete all the content except what is in the top-left cell. If the other cells contain data you need, copy it somewhere else first, or undo the merge when ready after to get it back.

What if I merge cells and then realize I need to sort the data?

Unmerge the cells first. Select the merged cell, go to Home, click the arrow next to Merge & Center, and choose Unmerge Cells. Then you can sort normally. Your data will be in the top-left cell of where the merge was.

Can I merge cells in different rows and columns at the same time?

No. You can only merge a rectangular block of cells — for example, cells A1 through C3. You cannot merge A1, C1, and A3 together because they do not form a rectangle. Select a continuous range of cells to merge.

Does merging cells change the file size of my spreadsheet?

Merging cells does not significantly change file size. The merged cell still takes up the same amount of space in the file as the original cells did. Formatting and merged cells are stored as instructions, not as extra data.

Can I merge cells in Google Sheets the same way as Excel?

Google Sheets has a merge cells feature, but it works slightly differently. Select your cells, go to Format menu, choose Merge Cells, and pick your merge type. The basic idea is the same, but the menu location is different. Google Sheets also has the same limitation — merged cells can interfere with sorting and filtering.