Loading...

Welcome to StudyVen

Enables you to add a non-adjacent cell or range to a selection of cells by using the arrow keys. : Shift+F8
Performs the Size command when a workbook is not maximized. : Ctrl+F8
Displays the Macro dialog to create, run, edit, or delete a macro. : Alt+F8
Calculates all worksheets in all open workbooks. : F9
Calculates the active worksheet. : Shift+F9
Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. : Ctrl+Alt+F9
Rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. : Ctrl+Alt+Shift+F9
Minimizes a workbook window to an icon. : Ctrl+F9
Turns key tips on or off. (Pressing Alt does the same thing.) : F10
Displays the shortcut menu for a selected item. : Shift+F10
Displays the menu or message for an Error Checking button. : Alt+Shift+F10
Maximizes or restores the selected workbook window. : Ctrl+F10
Creates a chart of the data in the current range in a separate Chart sheet. : F11
Inserts a new worksheet. : Shift+F11
Opens the Microsoft Visual Basic For Applications Editor, in which you can create a macro by using Visual Basic for Applications (VBA). : Alt+F11
Displays the Save As dialog. : F12
Displays the Key Tips (new shortcuts) on the ribbon. : Alt
Switches the worksheet to Page Layout view. : Alt, W, P
Switches the worksheet to Normal view. : Alt, W, L
Switches the worksheet to Page Break Preview view. : Alt, W, I
Move one cell up, down, left, or right in a worksheet. : Arrow keys
Moves to the edge of the current data region in a worksheet. : Ctrl+Arrow key
Extends the selection of cells by one cell. : 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. : Ctrl+Shift+Arrow key
Opens a selected drop-down list. : Down or Alt+Down arrow key
Deletes one character to the left in the Formula Bar. : Backspace
Also clears the content of the active cell. : 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. : Delete
In cell editing mode, it deletes the character to the right of the insertion point. : Delete