Format Cells Dialog

The Format Cells dialog is used to adjust the format of a single cell or a range of cells in the spreadsheet.

To open the Format Cells dialog:

  1. Select the cell or range of cells that you want to format.

  2. On the Format menu, click Cells.

    Tip: You can also use the Spreadsheet Editor – Right-click Menu and select Cells.

Font Tab

Click the Font tab to select the font, the font style, the font size, the Foreground color (color of the text) and the Background color (color of the cell).

By checking the Default font checkbox, you will set your changes as the default settings for all of the cells in the spreadsheet.

Note:
  • The list of available fonts depends upon the fonts loaded on the host PC. If a job is loaded onto a PC that does not have that font, the default font of that PC will be used instead.
  • Changes to foreground and background colors are ignored for any cell containing the ColorLabel function.
  • If a cell containing a PlotString function is highlighted, the Font, Font Style and Font Size formatting are applied to the PlotString cell and the plotted text string.

Tip: By using the Font box, the Font Size box, the Bold button, Italic button, Background Color, Foreground Color, or the Increase Font Size or Decrease Font Size buttons on the Toolbars, you can change the formatting of the text without opening the Format Cells dialog.

Alignment Tab

Click the Alignment tab to align data in the cell(s) to the Left, Center or Right, horizontally or to the Top, Center or Bottom, vertically. To restore the default alignment, click General.

Tip: The cell alignment can also be set from the Toolbars by using the Align Left, Center or Align Right buttons.

Number Tab

Click the Number tab to set the decimal place values of the numeric values in cells from 0 to 6 places. The default setting is 3.

Tip: The decimal number format can also be set from the Toolbars by using the Increase Decimal and Decrease Decimal buttons.

Graphics Tab

Click the Graphics tab to format the line width of cell graphics and the scale of graphic overlay text. The formatting only applies to the cell(s) containing a function that has an associated interactive graphic or result graphic.

  • Font: Formats the font for graphic overlay text. All text associated with the formatted cell(s) will use the same font.
  • Size: Formats the font size for graphic overlay text. All text associated with the formatted cell(s) will use the same font size.
  • Line Width: Formats the line width (measured in pixels) for cell graphics. All graphics associated with the formatted cell(s) will use the same line width. (1 - 10; default = 1)