Share via

Excel on a Mac - Merge cells in a table?

Anonymous
2017-04-20T17:24:43+00:00

Hi - I want to merge 2 cells in a templated table. The tab <Merge and centre> is dimmed. What do I do?

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. Bob Jones AKA CyberTaz MVP 435K Reputation points
    2017-04-20T21:06:41+00:00

    The cells in an Excel Table cannot be merged.

    What may be suitable is to select the cells then go to Format> Cells - Alignment& choose Center Across Selection from the Horizontal Alignmentlist. However, that works if only 1 (leftmost) cell has content, which pretty much negates the purpose & integrity of a Table.

    7 people found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bob Jones AKA CyberTaz MVP 435K Reputation points
    2017-05-05T13:48:25+00:00

    Not being sarcastic, but it wasn't posted in reply to you :-)

    If you post a New Question of your own stating all particulars relevant to your situation you'll get replies that address it. Please be sure to specify version update levels for both Office & OS X as well.

    0 comments
  2. Anonymous
    2017-05-05T00:42:36+00:00

    This did not work for me, but thanks.

    0 comments
  3. Anonymous
    2017-04-22T01:53:49+00:00

    Hi Graysl,

    Do you need further assistance on this? Have you referred on Bob's post?

    Thanks,

    Mike

    0 comments