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:
Shows the list of all functions. If the list is already displayed, the shortcut shows or hides the selected function syntax and description.
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.
In the formula, adds cursors to all occurrences of the selected part of your formula or of the part where the cursor currently stands.
Converts your formula to a tree view.
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.
It would be helpful if the formula editor had the ability to write comments to document formulas , that would only be visible in the Formula Editor (I know excel does not support this). And also line numbers.
Thank you for the suggestion. I'll pass it to our developers for consideration.
Why does it not work with latest office 365?
Thank you for the comment. For us to better understand the issue, please email us at email@example.com and describe the problem in more detail. Any screenshots illustrating the problem will help a lot. Thank you.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!