Loading...

Welcome to StudyVen

Refresh data in the current worksheet : Ctrl+F5
Create, run, edit, or delete a macro. : Alt+F8
Open the Microsoft Visual Basic For Applications Editor. : Alt+F11
Paste a name from the Paste Name dialog (if names have been defined in the workbook. : F3
Move to the first field in the next record of a data form. : Enter
Create a chart of the data in the current range in a separate Chart sheet. : F11
Define a name to use in references. : Alt+M, M, D
Copy the value from the cell above the active cell into the cell or the formula bar. : Ctrl+Shift+Straight quotation mark (")
Create an embedded chart of the data in the current range. : Alt+F1
Cycle through all combinations of absolute and relative references in a formula if a cell reference or range is selected. : F4
Insert a function. : Shift+F3
Insert the AutoSum formula : Alt+=
Invoke Flash Fill to automatically recognize patterns in adjacent columns and fill the current column : Ctrl+E
Insert argument names and parentheses when the insertion point is to the right of a function name in a formula. : Ctrl+Shift+A
Display the menu or message for an Error Checking button. : Alt+Shift+F10
Display the Function Arguments dialog when the insertion point is to the right of a function name in a formula. : Ctrl+A
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. : Ctrl+Alt+F9
Check dependent formulas, and then calculate all cells in all open workbooks, including cells not marked as needing to be calculated. : Ctrl+Alt+Shift+F9
Calculate all worksheets in all open workbooks. : F9
Calculate the active worksheet. : Shift+F9
Move the cursor to the end of the text when in the formula bar. : Ctrl+End
Select all text in the formula bar from the cursor position to the end. : Ctrl+Shift+End
Cancel an entry in the cell or Formula Bar. : Esc
Complete an entry in the formula bar and select the cell below. : Enter
Edit 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
Expand or collapse the formula bar. : Ctrl+Shift+U
Expand grouped rows or columns. : While hovering over the collapsed items, hold SHIFT and scroll down.
Collapse grouped rows or columns. : While hovering over the expanded items, hold SHIFT and scroll up.
Repeat the last command or action, if possible. : Ctrl+Y
Undo the last action. : Ctrl+Z