Expand Formula

Combines one level of precedent formulae into the current rendered equation.

Usage

Use Expand Formula repetitively to achieve the designed expansion of the selected formula.

Example 9

Download the 'Example spreadsheet' and follow the steps below:

Open tab 'Example 9'
Select cell C6, which contains the formula "=C4*C3".
Select any of the main rendering buttons, in this case we used Cell Name

example 9 — Example 9: Style: Excel Buttons:

Click the Expand button to include more detail within the rendered equation:

example 9.1 — Example 9: After Expansion Style: Excel Buttons:

Example 9: After Expansion Style: Excel Buttons:

Continued use of the Expand button will add additional precedent formulas into the rendered equation, i.e.

example 9.1 — Example 9: After Expansion Style: Excel Buttons: x 2

Example 9: After Expansion Style: Excel Buttons: x 2