Shortcut Keys

This is a list of all the shortcut keys related to calculation.

F9Smart Calculation. Calculates All the worksheets in All the open workbooks.
(only cells containing formulas that have changed since the last calculation, will be updated).
Replaces the highlighted part of a formula with its result to help debug when using the formula bar.
Shift + F9Smart Calculation. Calculates the Active worksheet in the Active workbook.
(only cells containing formulas that have changed since the last calculation, will be updated).
Ctrl + Alt + F9Full Calculation. Calculates All the worksheets in All the open workbooks.
(all cells containing formulas).
Ctrl + Alt + Shift + F9Full Recalculation. Calculates All the worksheets in All the open workbooks.
(all cells containing formulas).
(rebuilding the dependency tree and calculation chain).
Ctrl + Shift + F9This is not a default shortcut key but some third party add-ins use this for performing a Full Calculation of all the cells in the Active workbook.

This is a list of all the shortcut keys related to formulas.

=Start a Formula.
F2Allows you to edit the active cell directly, putting the cursor at the end. This is only available when the following option is ticked. (Advanced, Editing options - allow editing directly in cells). If this option is not checked the cursor will move to the Formula Bar.
F3Displays the Paste Name dialog box for inserting named ranges into a formula. This dialog box is only displayed if the active workbook contains at least one named range.
F4Lets you toggle between relative, absolute and mixed cell references when in the formula bar.
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).
Ctrl + Shift + AInserts argument names given a function in the formula bar.
Ctrl + Shift + UToggles the display of a multi-line 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 + /Selects all the cells that are part of the Same Array Formula which has been entered into the active cell.
Ctrl + ~You can toggle between displaying the values and formulas by pressing
F2, F9Pastes a formula as values.
Ctrl + ADisplays the Function Arguments dialog box when pressed after entering an equal sign followed by the function name.
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.
Alt + =Enters the SUM function (AutoSum) to sum the adjacent block of cells.
Alt + F, TDisplays the Excel Options dialog box.
Alt + M, HToggles between displaying cell values and formulas.

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext