Sophisticated formulas in Excel can be challenging to write and inconvenient to edit in the formula bar or a cell. Formula Editor converts formulas to a tree view so that you can comfortably write, change, or copy them.
All changes you make using Formula Editor refer to a cell whose address you can see on the tool pane.
You can install WebView2 from the Microsoft website using a download link that is provided under "Evergreen Bootstrapper" at the very bottom of this page: https://developer.microsoft.com/en-us/microsoft-edge/webview2/.
To start working with the tool, select the cell with the formula you want to edit and click Formula Editor in the Formulas group on the Ablebits Tools tab.
The tool pane with your formula in a tree view will show up:
You can choose any cell on your worksheet and see the cell contents and address on the Formula Editor pane immediately.
The formula is copied in its standard view (like it is shown in the formula bar).
Or, select the Compact style option.
Clear this checkbox if you want to move between cells on your worksheet without displaying cell contents on the Formula Editor pane.
Here are the keyboard shortcuts that come in handy when you edit a formula:
Ctrl+Space
Shows the list of all functions. If the list is already displayed, the shortcut shows or hides the selected function syntax and description.
Alt+Left click
Sets an additional cursor in the formula you're editing. Hold the Alt key and by clicking parts of your formula add as many cursors as you need.
Ctrl+F2
In the formula, adds cursors to all occurrences of the selected part of your formula or of the part where the cursor currently stands.
Alt+Shift+F
Converts your formula to a tree view.
Ctrl+Shift+Space
Shows a hint on the current function parameter. When the hint is displayed, use arrow keys on your keyboard to move inside the formula and see hints on other parameters.
Alt+Up arrow key
Swaps the current line in the formula tree with the line above.
Alt+Down arrow key
Swaps the current line in the formula tree with the line below.
Shift+Alt+Up arrow key
Copies the current line and pastes it above.
Shift+Alt+Down arrow key
Copies the current line and pastes it below.
Please contact us here