Share via

In Office 365 Excel how do I merge cells in a table

Anonymous
2019-05-12T02:07:35+00:00

How do you merge cells within a table? The quick merge button is greyed out, the table has not be shared, the layout tab isn't there in the table tools and I am using the desktop version. 

All of your guides for this only exist for power point and word... Why in the world would you remove a common table feature from the program purposed for making tables?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2019-05-12T04:41:32+00:00

    Hi Tim,

    Yes, we cannot merge cells in a table directly in Excel. If you want to merge cells in a table, we suggest you try the following steps to achieve it:

    1.Create a table and click any cell in the table. You will see Design tab in the Ribbon.

    2.Click Design tab >Click Convert to Range in Tools to convert the table to the range.

    3.You can merge the cells in the range.

    4After that, you need to select the range and click Insert to make it as a Table again.

    Hope this helps.

    Regards,

    Eli

    10+ people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-05-14T09:34:02+00:00

    Hi Tim,

    May I know if you refer to the information mentioned? Feel free to post back if you need further assistance.

    Regards,

    Eli

    0 comments