Pretty Formula

Enable Editing

Introduction

Pretty Formula
formats long and complex formulas
to make them easy to read and understand
to make your daily Excel life Pretty.

Pretty Formula makes you 10% happier in your daily Excel life. No more headache to read long and complex formulas in your spreadsheets!

  1. Pretty Formula automatically displays a long and complex formula in several lines with appropriate indentations.
  2. Therefore, you could understand better the logic in the formula.
  3. Anytime, you could format, modify, and unformat the formula in the editor.
  4. Finally, you could write a modified formula back to spreadsheet.

Get Started

The quickest way to get started is to click below and download the workbook sample. You don't need to find the add-in yourself, because opening the workbook will auto-open the Pretty Formula add-in (you may need to Trust this add-in). Then you will be able to navigate through complex formulas, and see how reading formulas become pleasant.

Download PrettyFormula-Sample-EN.xlsx

Screenshots

Enable Editing

Instructions

  1. Load the Pretty Formula add-in, click on the Pretty Formula button in the ribbon under the Pretty Formula tab.
  2. Turn the toggle On.
  3. Select a cell that contains a long and complex formula (e.g., containing IF or VLOOKUP function), then you will see how it is formatted in the editor. If our algorithm considers unnecessary to change the format of the formula, the formula will be unchanged.
  4. Navigate through cells in the workbook, the editor always tries to format the formula of the selected cell.
  5. You could edit the formula in the editor, that will not impact the cell content immediately.
  6. Anytime, Format (resp., Unformat) button tries to format (resp., unformat) whatever in the editor.
  7. Manually adjusting Width Limit gives you different formats of a formula.
  8. Finally, the Unformat & Write to cell button tries to unformat the formula in the editor and write it back to the selected cell.
  9. Turn the toggle Off when you want to disassociate the editor to your selection on the workbook.

Creative Algorithm

For the time being, Pretty Formula is the only one formatter of formulas listing in the Microsoft add-in store. It is the version 2 of our previous product "Formula Formatter". Pretty Formula is innovative in the following aspects:

  1. We have created a brand-new framework to intelligently pretty-print an Excel formula. For example, a function or an arithmetic expression will no longer be formatted in the same way all the time; many factors such as width limit, its surroundings, and other parts of the formula will be taken into account.
  2. The framework is extensible such that we could easily add or remove formatting rules for a class of formulas.
  3. The editor is based on Monaco Editor, that nobody uses so far for formula displaying. Monaco Editor has many advanced features that we will leverage for formula editing, such that coloring, intellisense, auto-complete, etc.

Video