Shortcut Keys

F9Smart Recalculation, all cells, all open workbooks
Shift + F9Smart Recalculation, all cells, all selected worksheets
Ctrl + Shift + F9Full Calculation, all cells, all open workbooks
Shift + Ctrl + Alt + F9Full Calculation, all cells, all open workbooks (with dependency tree and calculation chain)
Ctrl + [Selects all the cells that are directly referred to by the formula in the active cell (precedents).
Ctrl + ]Selects all the cells that directly refer to the active cell.
Ctrl + `Toggles between displaying cell values and formulas (single left quotation, not apostrophe).
Ctrl + 'Enters the formula from the cell directly above into the active cell (apostrophe).
F2Allows you to edit the cell directly without using the Formula Bar.
F4Lets you toggle between relative, absolute and mixed cell references when in the formula bar.
F9Calculates all the formulas in all the open workbooks.
Ctrl + Shift + AInserts argument names given a function in the formula bar.
Ctrl + Shift + [Selects all the cells that are directly or indirectly referred to by the formula in the active cell.
Ctrl + Shift + ]Selects all the cells that directly or indirectly refer to the active cell.
Ctrl + Shift + EnterMust be used to enter your array formulas.
Ctrl + /Highlights the cells that are used in the array formula.
Ctrl + ~You can toggle between displaying the values and formulas by pressing
F2, F9Pastes a formula as values.
Ctrl + HomeMoves to the beginning of a formula when you are editing it.
Ctrl + EndMoves to the end of a formula when you are editing it.

© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top

PrevNext