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

  Action or command   Keyboard shortcut    
Calculate Now Shift--=

Cancel an entry Esc

Clear cell contents and format Clear

Copy Format Shift--C

Delete cell contents Delete, Del

Delete Cells Shift--K

Enter an absolute cell reference in a formula -Option while you click the cell

Explode/collapse a pie slice Option while you click the series box in the chart legend

Fill Down -D

Fill Right -R

Go To Cell -G

Insert Cells Shift--I

Make Chart -M

Modify Chart (Chart Options) Double-click the chart

Modify chart element Double-click the element

Modify Frame (Frame Info) Press and double-click the frame

Number Format Select the cell and press Shift--N, or double-click the cell

Paste Format Shift--V

Go to a function in the Insert Function dialog box Type the first few letters of a function

Open a spreadsheet frame as its own document Option and double-click the selected frame

Sort -J

Spreadsheet selection and navigation keyboard commands

  Action or command   Keyboard shortcut    
Accept current entry and move one cell down* Return, Down Arrow

Accept current entry and move one cell left* Shift-Tab, Left Arrow

Accept current entry and move one cell right* Tab, Right Arrow

Accept current entry and move one cell up* Shift-Return, Up Arrow

Accept current entry and stay in the current cell Enter

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

*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

  Using the Button Bar, contextual menus, and keyboard shortcuts

 
Table of contents Index