Control of block- and cell-level text formatting in the worksheet.
Apply formatting to Standard (whole sheet), Column Labels, Data, Column Header, Row Header, Long Name, Units, Comments or F(x)=. Note that the availability of the options below will be dynamically changed with different selection of Apply To.
Enable rich text formatting (for example, superscript and subscript) for the selected cells. Note that when this check box is selected, the Wrap Text, Float, and Ellipsis controls will be ignored.
Allow the use of Enter within a cell. When selected, double-click in the cell, or single-click + F2 allows editing of cell contents. Press Shift + Enter to force text onto the next line.
If text length exceeds cell width, text is wrapped automatically to fit within the cell. Wrap Text prevents wrapping in the middle of words, which means:
Permits text in a cell to flow into the cell to the right.
Disables editing of affected cells. Not available when Apply To is set to Column Header or Row Header.
When text length exceeds cell width and floating and wrapping are disabled, an ellipsis can be displayed to indicate that the complete text is not shown. Without an ellipsis (Ellipsis = None), a number such as "1.2345678E9" may appear as "1.234" in a narrow column, while with ellipsis is set to ... or ###, the overflowed text will be displayed either with ... suffix or repeating # to fill in all cells respectively.
Merge adjacent cells containing the same text. Use the drop-down list to specify which direction to merge: horizontal, vertical, or both.
This check box is only available when you select Data or Standard for the Apply to drop-down list.
By default, a missing value in a cell is displayed as "--". Select this check box to hide the "--" and show cells with missing values as empty.