Office
Sign in
Add and format tables and charts

Merge and split table cells

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

To extend content across multiple rows or columns in a table, merge cells to create a larger cell. Or, split cells into smaller cells.

Merge cells

  1. Select the cells that you want to merge.

  2. Select Layout > Merge Cells.

    To unmerge cells, select the cells and select Unmerge Cells.

    Note: In Excel, select the cells you want and select Merge & Center. To unmerge cells, select the cells and select Unmerge Cells.

Split cells

  1. Select the cell that you want to split.

  2. Select Layout > Split Cells.

  3. Enter the number of columns or rows that you want to split the selected cell into, and then select OK.

Want more?

Merge or split cells in a table

Word training

PowerPoint training

Excel training

Outlook training

You can merge or split table cells however you’d like, to better organize your table.

For example, to make Monthly Sales the header for all of the months rather than for a single column.

Select the cells you want to combine.

Select Layout, and then Merge Cells.

And center the heading, Monthly Sales.

To add a quarterly sales heading, select the header row, and then select Split Cells.

To have a column for quarter 1 and one for quarter 2, leave the number of columns as 2 and select OK.

And add your header text: "Q1 Sales" and "Q2 Sales"

In Excel, you can’t merge cells in tables, but you can in spreadsheets.

To make Monthly Sales the header for all of the months, select the cells you want to merge, and then in Home, select Merge & Center. When you merge cells, you lose any data in the second cell.

To unmerge them, select Unmerge Cells.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×