Cell format dialog

Revision as of 01:44, 9 February 2017 by Max (talk | contribs)

New to Analytica 5.0

The Cell format dialog lets you set various styles and formats for cells in a Table view. It includes tabs for Fill, Alignment, Font, and Border styles, each described below, and Number format explained on its own page.

To open the Cell Format dialog

  1. Show a result table or edit table.
  2. Select the cell, row, column, or region whose format you want to modify.
    • To select the entire table, click the top left cell, above row headers and to left of column headers, or press ctrl-A (for select All)
    • To select an entire row or column, click on its header cell.
    • To select a rectangular range, press on a cell and drag to the opposite corner cell
  1. Then do one of these:
    • Select Cell format.. from the Result menu
    • Right-click on and select Cell format.. from the right-click menu
    • Press Ctrl+Alt+F, which opens the dialog on the last tab you used
    • Press Ctrl+B, which opens the dialog on the Number format tab

It is important to select the table region you want to format before you open the Cell format dialog because the Dialog is "modal" -- that means you can't modify the region unless you close the dialog, reselect the region, and reopen the dialog. (Yes, we know this is lame. We'll fix it in a future release.)

Fill format tab

Alignment format tab

Font format tab

Border format tab

History

Added in Analytica 5.0

See also

Number format

Comments


You are not allowed to post comments.