Work with data, functions, and the formula bar: keyboard shortcuts
Select an entire PivotTable report.
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.
Expand or collapse the formula bar.
Cancel an entry in the cell or Formula Bar.
Complete an entry in the formula bar and select the cell below.
Move the cursor to the end of the text when in the formula bar.
Select all text in the formula bar from the cursor position to the end.
Calculate all worksheets in all open workbooks.
Calculate the active worksheet.
Calculate all worksheets in all open workbooks, regardless of whether
they have changed since the last calculation.
Check dependent formulas, and then calculate all cells in all open
workbooks, including cells not marked as needing to be calculated.
Display the menu or message for an Error Checking button.
Display the Function Arguments dialog box when the insertion point is
to the right of a function name in a formula.
Insert argument names and parentheses when the insertion point is to
the right of a function name in a formula.
Invoke Flash Fill to automatically recognize patterns in adjacent columns
and fill the current column
Cycle through all combinations of absolute and relative references in a
formula if a cell reference or range is selected.
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.
Create a chart of the data in the current range in a separate Chart sheet.
Define a name to use in references.
Paste a name from the Paste Name dialog box (if names have been
defined in the workbook.
Move to the first field in the next record of a data form.
Create, run, edit, or delete a macro.
Open the Microsoft Visual Basic For Applications Editor.