Context Sensitive Menus

From within a cell, row number, or column header in TableView, right-click to display the following context menu items.

Cell Context Menu

Cut

Cuts unevaluated plain text and stores it to the clipboard. If another cut or copy action is performed, this text is lost.

Note: Formulas contained in a cell are lost in a cut and paste operation.

Copy

Copies unevaluated plain text and stores it to the clipboard. If another cut or copy action is performed, this text is lost.

Paste

Pastes a copied or cut text from the clipboard into a cell. You can also copy and paste the TableView data into an Excel spreadsheet, and conversely, copy and paste Excel data into TableView. TableView supports multiple lines of data in a single cell. To insert a line break within a cell, press Alt + Enter.

Note: Formulas contained in a cell are lost in a cut and paste operation.

Font

Displays the Font Selector dialog. From this dialog, change the font type, style, and size of the selected cells.

Alignment

Select Horizontal or Vertical.

Horizontal: Select Auto, Left, Center or Right to align data within the cell. By default, cell data that contains alpha characters (strings) are aligned to the left and cells that contain only numeric (scalar) data are aligned to the right.
Vertical: Select Auto, Top, Middle or Bottom to align data within the cell.

Text Color

Select a color from the palette to set the text color.

Background Color

Select a color from the palette to set the cell background color.

Merge Cells by Column

Cells can only be merged if they are adjacent to each other and in the same row; merging columns is not possible.

Note: If the selected cells are in different rows, this option is disabled.

If you select a merged cell and adjacent unmerged cells, selecting the Merge Cells Across Columns option merges the unmerged cells with the merged cell. This is disabled if cells in multiple rows or non-adjacent cells in the same row are selected.

Unmerge Cells by Column

Merged cells can be unmerged regardless of whether they are adjacent or in the same row. In the case of unmerging previously-merged cells, the contents of the merged cell is automatically placed in the first unmerged cell. For example, if cells C3-G3 have been merged, and you unmerge them, the contents of the merged cell are placed into C3.

Merge Cells by Row

Cells can only be merged if they are adjacent to each other and in the same column; merging columns is not possible.

Note: If the selected cells are in different columns, this option is disabled.

If you select a merged cell and adjacent unmerged cells, selecting the Merge Cells Across Rows option merges the unmerged cells with the merged cell. This is disabled if cells in multiple columns or non-adjacent cells in the same column are selected.

Unmerge Cells by Row

Merged cells can be unmerged regardless of whether they are adjacent or in the same column. In the case of unmerging previously-merged cells, the contents of the merged cell is automatically placed in the first unmerged cell. For example, if cells C3-G3 have been merged, and you unmerge them, the contents of the merged cell are placed into C3.

Border

Displays the Border dialog. Select a border style to apply to the selected cell(s). Use the Thickness drop-down menu to change the border's line thickness. Click Apply to apply your selection immediately. Click OK to close the dialog.

Row Context Menu

Insert Above: Inserts a row above the selected row.
Insert Below: Inserts a row below the selected row.
Cut: Removes the selected row and stores the evaluated plain text in the clipboard. If another cut or copy action is performed, this text is lost.
Copy: Copies evaluated plain text from the selected row and stores it to the clipboard. If another cut or copy action is performed, this text is lost.
Paste: Pastes rows from the clipboard. This option is disabled if the clipboard is empty (nothing has been cut or copied).

Column Context Menu

Insert: Inserts a column to the left of the selected column.
Cut: Removes the selected column and stores the evaluated plain text in the clipboard. If another cut or copy action is performed, this text is lost.
Copy: Copies evaluated plain text from the selected column and stores it to the clipboard. If another cut or copy action is performed, this text is lost. If multiple cells are selected, the same number of cells need to be selected to paste them correctly.
Paste: Pastes columns from the clipboard. This option is disabled if the clipboard is empty (nothing has been cut or copied).
Adjust the width: Adjusts the column width to accommodate the text or numbers in the cell, increasing or decreasing the size as necessary.