|
Ctrl+Enter : Fills the selected cell range with the current entry.
|
|
Shift+Enter : Completes a cell entry and selects the cell above.
|
|
Enter : Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by default).
|
|
Alt+Enter : Starts a new line in the same cell.
|
|
Ctrl+End : Moves to the last cell on a worksheet, to the lowest used row of the rightmost used column. If the cursor is in the formula bar, Ctrl+End moves the cursor to the end of the text.
|
|
Ctrl+Shift+End : Extends the selection of cells to the last used cell on the worksheet (lower-right corner). If the cursor is in the formula bar, Ctrl+Shift+End selects all text in the formula bar from the cursor position to the end—this does not affect the height of the formula bar.
|
|
Delete : In cell editing mode, it deletes the character to the right of the insertion point.
|
|
End+Right/Left/Up/Down : End turns End mode on or off. In End mode, you can press an arrow key to move to the next nonblank cell in the same column or row as the active cell. End mode turns off automatically after pressing the arrow key. Make sure to press End again before pressing the next arrow key. End mode is shown in the status bar when it is on.
|
|
Delete : In cell editing mode, it deletes the character to the left of the insertion point.
|
|
Delete : Removes the cell contents (data and formulas) from selected cells without affecting cell formats, threaded comments or notes.
|
|
Backspace : Deletes one character to the left in the Formula Bar.
|
|
Delete : Also clears the content of the active cell.
|
|
Down or Alt+Down arrow key : Opens a selected drop-down list.
|
|
Shift+Arrow key : Extends the selection of cells by one cell.
|
|
Ctrl+Shift+Arrow key : Extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.
|
|
Arrow keys : Move one cell up, down, left, or right in a worksheet.
|
|
Ctrl+Arrow key : Moves to the edge of the current data region in a worksheet.
|
|
Alt, W, L : Switches the worksheet to Normal view.
|
|
Alt, W, I : Switches the worksheet to Page Break Preview view.
|
|
Alt : Displays the Key Tips (new shortcuts) on the ribbon.
|
|
Alt, W, P : Switches the worksheet to Page Layout view.
|
|
Alt+F11 : Opens the Microsoft Visual Basic For Applications Editor, in which you can create a macro by using Visual Basic for Applications (VBA).
|
|
F12 : Displays the Save As dialog.
|
|
F11 : Creates a chart of the data in the current range in a separate Chart sheet.
|
|
Shift+F11 : Inserts a new worksheet.
|
|
Alt+Shift+F10 : Displays the menu or message for an Error Checking button.
|
|
Ctrl+F10 : Maximizes or restores the selected workbook window.
|
|
F10 : Turns key tips on or off. (Pressing Alt does the same thing.)
|
|
Shift+F10 : Displays the shortcut menu for a selected item.
|
|
Ctrl+Alt+Shift+F9 : Rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
|
