The shortcuts and hotkeys in Sourcetable are designed to make your life easier. They allow you to do things faster, without having to go through menus or dialogs. You can use them to navigate through your data, edit cells, insert formulas, create charts and much more. Below is a list of the shortcuts you can use in Sourcetable for both Mac and PC computers.
KEY - MAC | KEY - PC | Description |
Cmd+Z | Ctrl+Z | Undo the last action |
Cmd+Y | Ctrl+Y | Redo the last action |
Cmd+↓ | Ctrl+↓ | Navigates to the last row of the current selection |
↓ | ↓ | Navigates down to the next cell |
Fn+→ | End | Navigates to the end of the row |
Cmd+→ | Ctrl+→ | Navigates to the last column in the current selection |
Cmd+Fn+← | Ctrl+Home | Navigates to cell "A1" on the current sheet |
Fn+← | Home | Navigates to the first column in the selected row |
Cmd+← | Ctrl+← | Navigates to the first column in the current sheet |
Cmd+Fn+→ | Ctrl+End | Navigates to the last (bottom right) cell on the current sheet |
← | ← | Navigates one cell to the Left |
Tab | Tab | Navigates to the next cell to the right |
Fn+↓ | Page Down | Navigates to the next page of rows down |
Fn+↑ | Page Up | Navigates to the page of rows up |
Cmd+Fn+↑ | Ctrl+Alt+Page Up | Navigates to the previous sheet |
Cmd+Fn+↓ | Ctrl+Alt+Page Down | Navigates to the next sheet |
Shift+Tab | Shift+Tab | Navigates to the cell to the left |
→ | → | Navigates one cell to the right |
Cmd+↑ | Ctrl+↑ | Navigates to the first row of the current selection |
↑ | ↑ | Navigates one cell up |
Delete | Delete | Deletes the selected cells |
Fn+Delete | Back | Deletes the selected cell or the the leftmost cell in a row and the top cell in a column |
Enter | Enter | Enters the contents of the active cell and navigates to the cell above (by default) |
Shift+Enter | Shift+Enter | Enters the contents of the active cell and navigates to the cell below (by default) |
Esc | Esc | Cancels an entry |
Shift+← | Shift+← | Extends the cell selection to the left |
Shift+→ | Shift+→ | Extends the cell selection to the right |
Shift+↑ | Shift+↑ | Extends the cell selection up |
Shift+↓ |
Shift+↓ |
Extends the cell selection down |
Shift+Fn+← |
Shift+Home |
Extends the selection to the first column |
Cmd+Shift+← |
Ctrl+Shift+← |
Navigates across text, by whole words |
Shift+Fn+→ |
Shift+End |
Selects all text in the current line |
Cmd+Shift+→ |
Ctrl+Shift+→ |
Ctrl + Right navigates across text, by whole words |
Shift+Fn+↑ |
Shift+Page Up |
Extends the selection up one screen |
Shift+Fn+↓ |
Shift+Page Down |
Extends the selection down one screen |
Cmd+Shift+↑ |
Ctrl+Shift+↑ |
Selects the cells in the column from selection up and jumps to the top cell |
Cmd+Shift+↓ |
Ctrl+Shift+↓ |
Selects the cells in the column from selection down and jumps to the bottom cell |
Cmd+Shift+Fn+← |
Ctrl+Shift+Home |
Selects the cells in the column from selection left and jumps to the left cell in the row |
Cmd+Shift+Fn+→ |
Ctrl+Shift+End |
Selects the cells in the column from selection right and jumps to the right cell in the row |
Cmd+C |
Ctrl+C |
Copies the current selection |
Cmd+X |
Ctrl+X |
Cuts (Copies and Deletes) the current selection |
Cmd+V |
Ctrl+V |
Pastes selection |
Option+Enter |
Alt+Enter |
Enters a new line into a cell |
Shift+Space |
Shift+Space |
Selects the entire row |
Ctrl+Space |
Ctrl+Space |
Selects the entire column |
Cmd+- |
Ctrl+- |
Deletes the entire row or column |
Cmd+Shift+= |
Ctrl+Shift+= |
Inserts rows or columns depending on the selection |
Cmd+9 |
Ctrl+9 |
Hide select rows |
Cmd+Shift+9 |
Ctrl+Shift+9 |
Unhide select rows |
Cmd+0 |
Ctrl+0 |
Hide select columns |
Cmd+Shift+0 |
Ctrl+Shift+0 |
Unhide select columns |
Cmd+[ |
Ctrl+[ |
Selects all the cells that are directly referred to by the formula in the active cell (precedents) |
Cmd+] |
Ctrl+] |
Selects all the cells that directly refer to the active cell (dependents) |
Cmd+; |
Ctrl+; |
Inserts the current date into the selected cells |
Option+= |
Alt+= |
Enters the SUM() function (AutoSum) to sum the adjacent block of cells |
Option+; |
Alt+; |
Selects all visible cells in the current selection |
Cmd+D |
Ctrl+D |
Copies the first cell in the selection downwards |
Cmd+R |
Ctrl+R |
Copies the first cell in the selection right |
Cmd+A |
Ctrl+A |
Selects all from the current sheet |
Cmd+B |
Ctrl+B |
Bold cell text |
Cmd+I |
Ctrl+I |
Italicize cell text |
Cmd+Shift+X |
Ctrl+Shift+X |
Strikethrough cell text |
Cmd+U |
Ctrl+U |
Underline cell text |
Cmd+Shift+1 |
Ctrl+Shift+1 |
Set number format |
Cmd+Shift+3 |
Ctrl+Shift+3 |
Set date format |
Cmd+Shift+4 |
Ctrl+Shift+4 |
Set currency format |
Cmd+Shift+5 |
Ctrl+Shift+5 |
Set percent format |
Enjoy the speed and efficiency that you get with keyboard shortcuts!
