| Ctrl + Home |
Moves the cursor to the first cell in the sheet (A1). |
| Ctrl + End |
Moves the cursor to the last cell on the sheet that contains data. |
| Home |
Moves the cursor to the first cell of the current row. |
| End |
Moves the cursor to the last cell of the current row in a column containing data. |
| Ctrl + Left Arrow |
Moves the cursor to the left edge of the current data range. If the column to the left of the cell that contains the cursor is empty |
| Ctrl + Right Arrow |
Moves the cursor to the right edge of the current data range. If the column to the right of the cell that contains the cursor is empty |
| Ctrl + Up Arrow |
Moves the cursor to the top edge of the current data range. If the row above the cell that contains the cursor is empty |
| Ctrl + Down Arrow |
Moves the cursor to the bottom edge of the current data range. If the row below the cell that contains the cursor is empty |
| Ctrl + Shift + Arrow Keys |
Selects all cells containing data from the current cell to the end of the continuous range of data cells |
| Ctrl + Page Up |
Moves one sheet to the left. In the page preview it moves to the previous print page. |
| Ctrl + Page Up |
Moves one sheet to the left. In the page preview it moves to the previous print page. |
| Ctrl + Page Down |
Moves one sheet to the right. In the page preview it moves to the next print page. |
| Page Up |
Moves the viewable rows up one screen. |
| Page Down |
Moves the viewable rows down one screen. |
| Alt + Page Up |
Moves the viewable columns one screen to the left. |
| Alt + Page Down |
Moves the viewable columns one screen to the right. |
| Shift + Ctrl + Page Up |
Adds the previous sheet to the current selection of sheets. If all the sheets in a spreadsheet are selected |
| Shift + Ctrl + Page Down |
Adds the next sheet to the current selection of sheets. If all the sheets in a spreadsheet are selected |
| Ctrl + * |
Selects the data range that contains the cursor. A range is a contiguous cell range that contains data and is bounded by empty row and columns. The * key is the multiplication sign on the numeric key pad. |
| Ctrl + / |
Selects the matrix formula range that contains the cursor. The / key is the division sign on the numeric key pad. |
| Shift + F1 |
Displays context help |
| Ctrl + F1 |
Displays the note that is attached to the current cell. |
| F2 |
Switches to Edit mode and places the cursor at the end of the contents of the current cell. If the cursor is in an input box in a dialog that has a minimize button |
| Ctrl + F2 |
Opens the Function Wizard. |
| Shift + Ctrl + F2 |
Moves the cursor to the input line where you can enter a formula for the current cell. |
| Alt + Down Arrow |
Increases the height of current row. |
| Alt + Right Arrow |
Increases the width of the current column. |
| Alt + Shift + Arrow Keys |
Optimizes the column width or row height based on the current cell. |
| F12 |
Groups the selected data range. |
| Shift + F11 |
Creates a document template. |
| F9 |
Recalculates all of the formulas in the sheet. |
| F8 |
Turns additional selection mode on or off. In this mode |
| Ctrl + F8 |
Highlights cells containing numeric values (not text). |
| F7 |
Checks spelling in the current sheet. |
| F4 |
Shows or hides the Database Sources menu. |