You can right-click a worksheet cell and select Format Cell to open the wcellformat X-Function and edit cell formats.
Contents |
This is an uneditable textbox that displays the cell range you have selected.
This checkbox is used to specify whether rich text formatting (for example, superscript and subscript) is enabled for the selected cells. Please note that when this checkbox is selected, the Wrap Text, Float and Ellipsis will not be editable.
When this checkbox is unchecked, the format buttons 
are gray. While if the Rich Text is checked, double-click in the specified cell to make it to the edit state and chose part of the cell contents, then you can see these buttons are enabled. You can use them to apply rich text formatting.
This checkbox allow Enter to be used in the specified cell. If it is checked, double-click in the specified cell to make it to the edit state and use Shift+Enter to separate the text into different rows.
If the length of text exceeds the width of the cell, the text will be wrapped automatically to fit the cell width. If the Wrap Text checkbox is selected, Origin will not wrap in the middle of words. Otherwise, the words might be cut off in the middle due to the wrapping.
It allows text in this cell to overflow into the cell on its right. For example, suppose Float for Cell[1, 1] is checked. When the length of the text in Cell[1, 1] is greater than the cell width and Cell[1, 2] is empty, the text in Cell[1, 1] will overflow into Cell [1, 2], as shown in the below screenshot.
When this check box is checked, you can not type into or make any edit to the selected cell.
When text length exceeds cell width, you can opt to use floating or wrapping to proper display the text. However, if neither floating nor wrapping is used, ellipsis could be displayed to tell the user that the whole text cannot be fully shown.
This option is used to automatically merge adjacent cells that contain same text. Use this drop-down list to specify the dynamic merge direction. It can be Horizontal, Vertical or Both.
Use this drop-down list to select the formatting of the cell.
Specify display form for numeric, date and time data. This drop-down list provides 4 options for numeric data: Decimal: 1000, Scientific 1E3, Engineering: 1K and Decimal: 1,000. Several options are provided for date and time data. The functionality is same as the options in Column Properties dialog box. The only difference is that it controls the format for cells, and not the entire column.
Specify decimal number for numeric data. There are 3 options in drop-down list: Default Decimal Digits; Set Decimal Places=; Significant Digits=
This option is shown only when Digits is Significant Digits=. It is used to specify number of Significant Digits.
This option is shown only when Digits is Set Decimal Places = . It is used to specify number of decimal.
This option specifies the font for selected cells.
This option specifies the font size for selected cells.
This option specifies the text color in selected cells.
This option specifies the color filled in selected cells.
This button applies setting to selected cells without closing the dialog.
Apply setting to selected cells and Close the dialog.
Close the dialog and discard the changes.