Right-click Menu Commands (Spreadsheet)

Right-click menus (also called Shortcut menus) are menus that appear when you right-click on something. The GenStat spreadsheet includes a right-click menu that is activated when you click anywhere on a spreadsheet and provides shortcuts to some common spreadsheet facilities.

Copy

This command copies the current selection or cell to the Clipboard.

Cut

This command removes the current selection or cell and copies the data to the Clipboard.

Paste

This inserts the data from the Clipboard to the spreadsheet starting from the current cell. If the spreadsheet includes a selection data will be inserted within that selection.

Paste Special

Opens a dialog providing options to control how data are copied from the Clipboard to a spreadsheet. By default, data from the Clipboard are inserted in a spreadsheet starting from the current cell. If the spreadsheet includes a selection data will be inserted within that selection.

Fill

This command opens a dialog that can be used to fill a column with a sequence of values.

Rename

This command allows you to rename the column that the right-click menu was opened on.

Convert

This command allows you to convert the column that the right-click menu was opened on.

Convert to Variate

This command converts the column that the right-click menu was opened on to a variate column using the default conversion options.

Convert to Factor

This command converts the column that the right-click menu was opened on to a factor column using the default conversion options.

Convert to Text

This command converts the column that the right-click menu was opened on to a text column using the default conversion options.

Filter

This submenu has 4 items to filter the rows displayed in the spreadsheet and one to remove any restriction:

By Value	Restrict the spreadsheet on values in the column clicked on using the Restrict Units by Value dialog.
To Groups	Restrict the spreadsheet on values in the column clicked on using the Restrict using Factor Levels dialog.
Expression	Restrict the spreadsheet on values in the column clicked on using the Restrict using Expression dialog.
to Values = to the current cell	Restrict the spreadsheet to include rows that have values in the column clicked on the same as the currently active cell. Note: This item is the only option that allows restrictions based on text columns.
Remove All	remove all restrictions on the spreadsheet.

Protect Column

This changes the status of the column that the right-click menu was opened on to be protected (i.e. read only).

Sort

This command can be used to sort the rows within a spreadsheet.

Factor

This submenu provides access to dialogs that can be used to modify a factor:

Levels & Labels	This allows you to simultaneously modify the levels and labels of a factor.
Reorder	This can be used to reorder the factor levels.
Labels	This can be used to create or change the labels for a factor.
Levels	This can be used to create or change the levels for a factor.

Analysis

This submenu provides shortcuts to some quick analysis statistical menus.

Graph

This submenu provides shortcuts to some quick analysis graphics menus.

Column Attributes

This command opens a dialog that displays the attributes for the column that the right-click menu was opened on.

Properties

This command opens a dialog that displays the properties for the current spreadsheet.

Set as Active Sheet

This command sets the current sheet to be the active spreadsheet.

Toggle Bookmark

This command inserts or removes a bookmark for the current cell within the spreadsheet.

Bookmark Note

This command adds or displays a bookmark note (i.e. a comment) for the current cell within the spreadsheet.