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 | |
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 |