Spreadsheet Navigation and Shortcuts

There are a number of standard keys and keystroke combinations that make it easier to move rapidly within a GenStat spreadsheet or invoke spreadsheet functions.

Spreadsheet Navigation

KeyFunctionCtrl+Key
HomeFirst column of current rowFirst row of current column
EndLast column of current rowLast row of current column
PageUpMove up one pageMove to previous sheet in the book
PageDownMove down one pageMove to next sheet in the book
Ctrl+Shift+PageUpMove to first sheet in the book
Ctrl+Shift+PageDownMove to last sheet in the book

Spreadsheet Shortcuts

KeyFunction
EscapeClear Current Selection
CTRL+DelDelete
CTRL+ASelect All
CTRL+Alt+ABookmark by value
CTRL+Alt+BRebase date column
CTRL+CCopy
CTRL+Shift+CChange Case
CTRL+Alt+CSelect Current Column
CTRL+Shift+DDelete current row or row selection
CTRL+Alt+DDuplicate Column
Alt+Shift+DDelete Bookmark note
CTRL+EUpdate changed data to GenStat and close spreadsheet
CTRL+FFind
CTRL+Alt+FCalculate Factor
CTRL+Shift+FReorder Levels
CTRL+GGoto Cell
CTRL+Shift+GFill a column by Groups
CTRL+HDelete
CTRL+IInsert row before current row
CTRL+Shift+IInsert Multiple rows
CTRL+ALT+IInsert Clipboard
CTRL+JInsert row after current row
CTRL+Alt+KColumn Conditional Formatting
CTRL+Shift+LDDE Link
CTRL+Alt+LEdit Factor levels
Shift+Alt+LEdit Factor labels
Alt+NCopy Column Names
Shift+Alt+NPaste Column Names
CTRL+Alt+OColumn Reorder
CTRL+PPrint
CTRL+Alt+PProtect Column
CTRL+Alt+QToggle Selection of current cell
CTRL+RReplace
CTRL+Alt+RSelect Current Row
CTRL+Shift+RRepeat current row or row selection
Alt+Shift+RRename Column
CTRL+SSave File
CTRL+Alt+SStandardize Column
CTRL+Shift+SRandom Sample
ALT+Shift+SRandom Subset
CTRL+TFind Next
CTRL+Shift+TSplit text column
ALT+Shift+TCombine text columns
CTRL+Alt+TSet temporary missing value
CTRL+URefresh Sheet from GenStat
CTRL+Shift+USubset restriction to GenStat
CTRL+VPaste
Alt+VPaste Special
CTRL+Alt+WSet Default Column Widths
CTRL+XCut
CTRL+ZUndo

See Also