### Shortcut Keys

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

F9 | Smart Recalculation, all cells, all open workbooks |

Shift + F9 | Smart Recalculation, all cells, all selected worksheets |

Ctrl + Shift + F9 | Full Calculation, all cells, all open workbooks |

Shift + Ctrl + Alt + F9 | Full 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). |

F2 | Allows 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. |

F4 | Lets you toggle between relative, absolute and mixed cell references when in the formula bar. |

F9 | Calculates all the formulas in all the open workbooks. |

Ctrl + Shift + A | Inserts argument names given a function in the formula bar. |

Ctrl + Shift + U | Toggle the display of a large 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 + Enter | Must 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, F9 | Pastes a formula as values. |

Ctrl + Home | Moves to the beginning of a formula when you are editing it. |

Ctrl + End | Moves to the end of a formula when you are editing it. |

Alt + M, H | Toggles between displaying cell values and formulas |

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