Share via

alignment problem with Mac Excel

Anonymous
2016-03-18T21:25:37+00:00

I just converted from a PC to a MacBook Air and I am continuing to use Microsoft Excel for Mac.  I cannot get the text within merged and wrapped cells to fully justify: flush on the left of the cell, but not on the right?  The text on the right side has a noticeable gap and its uneven.  Thanks for your help.

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
    2016-03-19T14:52:54+00:00

    What you don't mention is whether you've selected Justify in Format> Cells> Alignment - Horizontal Alignment.

    Even with that applied, Mac Excel doesn't do Full/Forced Justification, nor does it support automatic hyphenation. Those typography features generally are found only in word processing/desktop publishing programs. It's unlikely that you'll get a razor sharp right edge to the text... there simply are too many variables beyond the scope of spreadsheet programs.

    3 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-03-19T14:44:47+00:00

    First, make sure that you are using compatible fonts, that is, a font that is available on both the PC and the Mac. Also make sure you run FontBook to check all your fonts and remove duplicates. After doing this, restart your Mac.

    Second, Never, Ever Ever use merged cells. They will cause all kinds (this is only one small issue) of problems as your workbook changes over time. The is always another way to get your headings to align and appear properly without using merged cells.

    1 person found this answer helpful.
    0 comments