1. Home
  2. Control Key Shortcuts

Control Key Shortcuts

The following control key combinations provide shortcuts to many of the more frequently used menu commands.

Key assignments marked with * relate to spreadsheet functions only.

Key Function Shift+Key Alt+Key
Ctrl+A Select All Add Note Bookmark by Value*
Ctrl+B Submit Batch File Display Note Rebase Date column
Ctrl+C Copy Change Case Select Column*
Ctrl+D Clear All Data    
Ctrl+E Update Data and Exit*   Excel import wizard
Ctrl+F Find Reorder Levels* Calculate Factor*
Ctrl+G Goto Line/Cell    
Ctrl+H Next Error Message Previous Error Message  
Ctrl+I Insert row before current row* Insert multiple rows*  
Ctrl+J Insert row after current row*    
Ctrl+K Submit Clipboard Submit to current line Conditional Format*
Ctrl+L Submit Line DDE Link* Edit Factor Levels*
Ctrl+M Submit Selection/Run Analysis* Submit from current line Move Column*
Ctrl+N Open New Text Window    
Ctrl+O Open File   Reorder Columns*
Ctrl+P Print   Protect Column*
Ctrl+Q (none) Cell Colours* Toggle Selection of Cell
Ctrl+R Replace Repeat Line Select Row*
Ctrl+S Save File Save File As  
Ctrl+T Find Next Text Split* Temporary Missing Value*
Ctrl+U Update Sheet*   Allow Auto Update*
Ctrl+V Paste Paste Special  
Ctrl+W Submit Window Recycle Window Default Column Widths*
Ctrl+X Cut    
Ctrl+Y Redo    
Ctrl+Z Undo    
Ctrl+Delete Delete    
Ctrl+0 Restrict Expression*    
Ctrl+1 Restrict on Cell*    
Ctrl+2 Restrict No Missing values*    
Ctrl+3 Restrict Missing Values*    
Ctrl+4 Reverse Restriction*    
Ctrl+5 Restrict Selection*    
Ctrl+6 Restrict Selected rows added to Excluded*    
Ctrl+7 Restrict Selected rows removed from Excluded*    
Ctrl+8 Restrict UnSelected rows as Excluded*    
Ctrl+9 Restrict UnSelected rows added to Excluded*    
Ctrl+0 Restrict UnSelected rows removed from Excluded*    
Ctrl+] Moves the cursor to next brace or matching statement    

Bookmark Shortcuts

The following key assignments provide shortcuts to bookmark functions:

Key Function Shift+Key Control+Key
Alt+A Toggle Display By Value
Alt+B Next Previous  
Alt+D   Delete Note  

Other Alt key Shortcuts

The following key assignments provide shortcuts to bookmark functions:

Key Function Shift+Key
Alt+K Insert Code Insert Command
Alt+N Copy Column Names* Paste Column Names*
Alt+Q   Swap Selected Cells*
Alt+R   Rename Columns*
Alt+T   Combine Text*

See also

Updated on December 3, 2020

Was this article helpful?