TABLECELL — Table Cell

Changes the selected cells of a table.

• Command: TABLECELL · Global name: _TABLECELL · Alias: CELLS

Changes the selected cells of a table: inserts or deletes rows and columns, merges or unmerges cells, and changes the alignment, height and color of the text, the fill and the contents.

Selecting cells

With no command running, click inside a cell to select it; Shift+click or dragging from one cell to another extends the range. The Table Cell palette appears; its buttons run TABLECELL:

• Rows: Insert Above, Insert Below, Delete Rows. Columns: Insert Left, Insert Right, Delete Columns.
• Merge Cells, Unmerge Cells and Edit Text (opens TABLEDIT).
• Alignment:, Text height:, Text color: and Fill:.
• Formula: Sum, Average or Count: with a single cell selected, the formula takes the data cells above it; with a range, the range.

Command line usage

1. Enter TABLECELL (or CELLS). If no cells are selected, click one.

Select a table cell:

2. Choose the option. Each change ends the command and is undone separately.

Cells … [EDit/Text/ABove/BElow/LEft/RIght/DeleteRow/DeleteColumn/Merge/Unmerge/ALign/Height/COlor/Fill/RAnge] <Exit>:

Options

• EDit (ED): edits the text. Text (T): writes the same contents in all the selected cells.
• ABove (AB), BElow (BE), LEft (LE), RIght (RI): insert as many rows or columns as are selected.
• DeleteRow (DR), DeleteColumn (DC): delete the selected ones; one always remains.
• Merge (M), Unmerge (U): merge the range into one cell or unmerge it.
• ALign (AL), Height (H), COlor (CO), Fill (F): text format and fill.
• RAnge (RA): selects another range, typed (B3 or A1:C4).

Notes

• Formulas do not shift their references when rows or columns are inserted or deleted.

See also

TABLE · TABLEDIT · TABLESTYLE · Tables