Formula Formatter
Introduction
Do you feel headache when you see long formulas in your spreadsheets? If so, Formula Formatter is your best friend!
- Formula Formatter automatically displays a long and complex formula in several lines with appropriate indentations.
- Therefore, you could understand better the logic in the formula.
- Anytime, you could format, modify, and unformat the formula in the text area.
- Finally, you could write a modified formula back to spreadsheet.
Elements in the Task Pane
- 1 toggle
- 1 text area
- 3 buttons
Instructions
- Load the add-in
- Turn the toggle on
- Select a cell that contains a long and complex formula (eg., containing IF or VLOOKUP function), then you will see how it is formatted in the text area. If our algorithm considers unnecessary to change the format of the formula, an exactly same formula will be displayed.
- You could edit the formula in the text area, that will not impact the cell content immediately.
- Anytime, “Format above” (resp., “Unformat above”) button tries to format (resp., unformat) whatever in the text area.
- Finally, “Unformat above and write to cell” tries to unformat the formula in the text area and write it back to the selected cell.
- Turn the toggle off when you want to disassociate the text area to your selection on the workbook.
Upcoming Features
We use trello to manage our product road-map and be interactive with you. Please feel free to make a feature request there, or to vote for upcoming features, eg.,:
- Colorize ranges in the formula in the text area and on the sheet
- After pasting a formula to a cell, formatting should be launched systematically
- Support Excel in French
- Support array formulas
Contact
For any question and issue, please write an email to: [email protected].