Spreadsheet shortcuts
| Select the entire table |
CTRL A |
| Select the top left most cell |
CTRL SHIFT A |
| Select the whole column when a cell is selected |
CTRL SPACE |
| Select the whole row when a cell is selected |
SHIFT SPACE |
| Move the selection up, down, left or right when a cell, range, row or column is selected; When the cell with focus is in an edit state, LEFT ARROW and RIGHT ARROW move the cursor between the characters in the cell |
ARROW KEYS |
| Move the focus right one cell |
TAB |
| Move the focus left one cell |
SHIFT TAB |
| Extend or reduce the current row or column selection |
SHIFT ARROW KEYS |
| Move a date forward or backward in time in multiples of the current snapping unit |
+/- (used in a date/time cell) |
| Turn one-task-per-line mode or off for the bar with the cell that currently has the focus |
+/- (on the numeric keypad) |
| Put the current cell into an edit state, if possible |
F2 |
| Commit the current edit and move the selection down one cell; when a range is selected, the focus moves to the next cell in the range |
ENTER |
| Cancel the current edit |
ESC |
| Move the cursor to the start of the string in an editable cell, or move to the top left cell in the current view |
HOME |
| Move the cursor to the end of the string in an editable cell, or move to the top right cell in the current view |
END |
| Move to the top left cell in the current view |
CTRL HOME |
| Move to the bottom right cell in the current view |
CTRL END |
| Select the current bar |
CTRL SHIFT B |
| Apply or remove bold formatting |
CTRL B |
| Apply or remove italic formatting |
CTRL I |
| Apply or remove underline formatting |
CTRL U |
| Display the right-click (context-sensitive menu) |
SHIFT F10 |
| Access an external document via a hyperlink |
ALT-click |
Related Topics:
File manipulation shortcuts
Bar chart scrolling shortcuts
Bar chart command shortcuts
View shortcuts
Window and view manipulation shortcuts
Library Explorer and Assignment View shortcuts