Spreadsheet keyboard shortcuts
You can use these general, selection, and navigation shortcuts in spreadsheet documents or spreadsheet frames. Some actions have two or more shortcuts.
General spreadsheet keyboard commands
Spreadsheet selection and navigation keyboard commands
|
|
|
|
|
|
|
To accept current entry and |
|
Keyboard shortcut |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Move one cell down |
|
Return, Down Arrow |
|
|
|
|
Move one cell left |
|
Shift-Tab, Left Arrow |
|
|
|
|
Move one cell right |
|
Tab, Right Arrow |
|
|
|
|
Move one cell up |
|
Shift-Return, Up Arrow |
|
|
|
|
Move one character left in the entry bar |
|
Left Arrow |
|
|
|
|
Move one character right in the entry bar |
|
Right Arrow |
|
|
|
|
Move to the beginning of data in the entry bar |
|
Up Arrow |
|
|
|
|
Move to the end of data in the entry bar |
|
Down Arrow |
|
|
|
|
Move selected cells to another location |
|
Option- while you click in the other location |
|
|
|
|
Select all cells in spreadsheet |
|
Click the selection box (where row and column headings intersect) |
|
|
|
|
Select all cells with data |
|
Option-click the selection box |
|
|
|
|
Stay in the current cell |
|
Enter |
|
|
|
Note: The way the arrow keys work depends on settings in the Preferences dialog box. If you've set the arrow keys to move the insertion point, you must hold down Option while pressing an arrow key to move to another cell.
Related topic
|