Bring back the "Paragraph" formatting feature for text boxes (previously available on the menubar)
Excel for Mac 2011 previously included an option to edit features such as text alignment, indentation, line spacing, and other paragraph-related formatting features from the Format - Paragraph option on the menu bar.
However, for some reason, this is missing completely from the menu bar on Excel 2016 for Mac. It is now only available when right-clicking inside a text box. Please see the following image for the menu:
The Paragraph menu items are not available from the new Format Shape - Text Options pane on the right-hand side of the screen, either. There are options for "Text Box" there, but nothing for "Paragraph". See the image below.
What this means is that it is now much more inconvenient to change the line spacing and other options related to paragraph formatting on Excel 2016.
I would really like to see these options returned to the menu bar, and added to the new Format Shape pane as well. Their absence makes working with text boxes in Excel 2016 extremely burdensome.
Agreed. There is no good way to set the top/bottom margin in a cell or provide paragraph spacing within a cell without this feature. Why does the 'new' version have less features?
Jim Jones commented
I too would like to change spacing between lines in a text box or the line height. I couldn't believe it wasn't there.
The program has all kinds of bells and whistles, but does not have the basic option of spacing the lines in a paragraph. It is frustrating!