Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×