Can’t merge cells in Excel 2008? (Mac)

Having problems merging cells in Excel 2008?

There are at least two solutions to this:

1. Use the SHIFT key, NOT the Command key, to select the cells you want to merge. Don’t ask me why that is. It just is.
2. Make sure the Workbook is NOT set to be shared. TOOLS>SHARE WORKBOOK>Uncheck the box that says “Allow changes by more than one user at the same time”

NOTE
The merge/unmerge cells button has become a checkbox in Excel 2008. Just click on the Toolbox icon in the top portion of Excel, and click on the triangle next to “Alignment and Spacing.” At the bottom of that section, under “Indentation and Merge,” you will see a checkbox that you need to check/uncheck, depending on whether you want to merge/unmerge. If it is grayed out, then you need to make sure that when you are selecting the cells that you want to merge/unmerge, that you are holding down the SHIFT key, and NOT the Command key

Listen to this post Listen to this post

Follow Us

Subscribe to our e-mail newsletter to receive updates.

3 Responses to “Can’t merge cells in Excel 2008? (Mac)”

  1. Mike Marullo Says:

    What happened to the Merge/Unmerge Cells icons and Tools-Customize Function in Mac Office 2008 Excel??

  2. Ian Brown Says:

    The merge/unmerge cells button has become a checkbox in Excel 2008. Just click on the Toolbox icon in the top portion of Excel, and click on the triangle next to “Alignment and Spacing.” At the bottom of that section, under “Indentation and Merge,” you will see a checkbox that you need to check/uncheck, depending on whether you want to merge/unmerge. If it is grayed out, then you need to make sure that when you are selecting the cells that you want to merge/unmerge, that you are holding down the SHIFT key, and NOT the Command key.

    For customizing the Toolbar, go to the “View” menu and select “Customize Toolbars and Menus.” I hope that’s what you were referring to. If not, let me know.

  3. Chris Says:

    Why can’t the document be shared? What does that have to do with cell merging?

    Microsoft is so frustrating

Leave a Reply