Pressing the Escape key will exit “Edit” mode and return the cell to its original formula.When you are finished evaluating your formula:.Be sure to highlight parts of your formula while in “Edit” mode before pressing F9, otherwise the entire formula will be simplified to its calculated value.Keep in mind two key things when evaluating a formula with “Edit” mode and the F9 key: This can be helpful for understanding how complex formulas are working, debugging why complex formulas are not working as expected, or for determining the source positioning of any error value. Once highlighted, pressing the F9 key calculates the highlighted portion and simply displays its value or result. Once you are in “Edit” mode, you have the flexibility to highlight any part of your formula to evaluate it, so long as it could have been evaluated as a stand-alone formula. To do this, you must first press the F2 key on your desired cell to activate “Edit” mode ( see our prior keyboard shortcut on the Double F2 key). To overcome these limitations, you can use the F9 key to evaluate your formula or subset of your formula. However, there are two key limiting factors to this feature: (i) you can only evaluate the formula from left to right, and (ii) edits cannot be made directly within the Evaluate Formula dialog box. This allows you to evaluate the formula on a cell by cell basis.
If you require additional insight into how your formula or subset of your formula is working, you can evaluate the formula on a more granular level using Excel’s Evaluate Formula feature (Alt + M + V). This is great for simply understanding how a formula works or for finding out the positioning of a #REF! error – especially over an area containing multiple cells. This toggles the display of the current worksheet, allowing you to switch views between cell values and cell formulas. The quickest way to evaluate a formula in Excel is to press CTRL + ~ (tilde). In Excel there are typically many ways to perform the same task, so it should be no surprise that there are multiple ways to evaluate formulas. What many people don’t know, however, is that F9 can also be used to understand and debug formulas. Evaluating an Excel Formula with “Edit” Mode and the F9 KeyĪlmost everybody knows that pressing the F9 key in Excel recalculates all of the worksheets within all of the workbooks that a user has open.
0 kommentar(er)
