Loading...

Welcome to StudyVen

DownEnd 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. : End+Right/Left/Up/
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+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. : Ctrl+Shift+End
Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by default). : Enter
Starts a new line in the same cell. : Alt+Enter
Fills the selected cell range with the current entry. : Ctrl+Enter
Completes a cell entry and selects the cell above. : Shift+Enter
Cancels an entry in the cell or Formula Bar. : Escape key
Closes an open menu or submenu, dialog, or message window. : Escape key
il also closes full screen mode when this mode has been applied, and returns to normal screen mode to display the ribbon and status bar again. : Escape key
Moves to the beginning of a row in a worksheet. : Home
Move to the first cell of selected column. : Ctrl+Up arrow
Move to the last cell of selected column. : Ctrl+Down arrow
Close a dialog or cancel a process, such as a paste operation. : Ctrl+Esc
Open the AutoFilter Menu dialog. : Alt+Down arrow
Open the Go To dialog. : F5
Recalculate all formulas in the Power Pivot window. For more information, see Recalculate Formulas in Power Pivot. : F9
Open the task pane options menu. : Ctrl+Spacebar
Close the task pane then select Close : .Ctrl+Spacebar,
Displays the Excel Help task pane. : F1
Displays or hides the ribbon. : Ctrl+F1
Creates an embedded chart of the data in the current range. : Alt+F1
Inserts a new worksheet. : Alt+Shift+F1
Edits the active cell and put the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar. If editing a formula, toggle Point mode off or on so you can use arrow keys to create a reference. : F2
Adds or Edits a cell note. : Shift+F2
Displays the print preview area on the Print tab in the Backstage view. : Ctrl+F2
Displays the Paste Name dialog. Available only if names have been defined in the workbook. : F3
Displays the Insert Function dialog. : Shift+F3
repeats the last command or action, if possible. : F4
Closes the selected workbook window. : Ctrl+F4