1. Home
  2. Spreadsheet Navigation and Shortcuts

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

Key Function Ctrl+Key
Home First column of current row First row of current column
End Last column of current row Last row of current column
Page Up Move up one page Move to previous sheet in the book
Page Down Move down one page Move to next sheet in the book
Ctrl+Shift+Page Up Move to first sheet in the book  
Ctrl+Shift+Page Down Move to last sheet in the book  
Alt+Page Up Scroll left one screen  
Alt+Page Down Scroll right one screen  

Spreadsheet Shortcuts

Key Function
Esc Clear current selection
Ctrl+Delete Delete
Ctrl+A Select all
Ctrl+Alt+A Bookmark by value
Ctrl+Alt+B Rebase date column
Ctrl+C Copy
Ctrl+Shift+C Change case
Ctrl+Alt+C Select current column
Ctrl+Shift+D Delete current row or row selection
Ctrl+Alt+D Duplicate column
Alt+Shift+D Delete bookmark note
Ctrl+E Update changed data to Genstat and close spreadsheet
Ctrl+F Find
Ctrl+Alt+F Calculate factor
Ctrl+Shift+F Reorder levels
Ctrl+G Goto Cell
Ctrl+Shift+G Fill a column by groups
Ctrl+H Delete
Ctrl+I Insert row before current row
Ctrl+Shift+I Insert multiple rows
Ctrl+Alt+I Insert clipboard
Ctrl+J Insert row after current row
Ctrl+Alt+K Column conditional formatting
Ctrl+Shift+L DDE link
Ctrl+Alt+L Edit factor levels
Shift+Alt+L Edit factor labels
Alt+N Copy column names
Shift+Alt+N Paste column names
Ctrl+Alt+O Column reorder
Ctrl+P Print
Ctrl+Alt+P Protect column
Ctrl+Alt+Q Toggle selection of current cell
Shift+Alt+Q Swap selected cells
Ctrl+R Replace
Ctrl+Alt+R Select current row
Ctrl+Shift+R Repeat current row or row selection
Alt+Shift+R Rename columns
Ctrl+S Save file
Ctrl+Alt+S Standardize column
Ctrl+Shift+S Random sample
Alt+Shift+S Random subset
Ctrl+Shift+T Split text column
Alt+Shift+T Combine text columns
Ctrl+Alt+T Set temporary missing value
Ctrl+U Refresh sheet from Genstat
Ctrl+Shift+U Subset restriction to Genstat
Ctrl+V Paste
Ctrl+Shift+V Paste special
Ctrl+Alt+W Set default column widths
Ctrl+X Cut
Ctrl+Z Undo
F3 Find next
Shift+F3 Find previous

See also

Updated on December 3, 2020

Was this article helpful?