Excel Formula Beautifier

This utility allows you to explore complex or very long Excel formulas by fully expanding them across multiple lines and indenting them.

Example

Before:

=INDIRECT(ADDRESS(9,MAX(IF(OR($AE13=$R13,$AL13=$R13,$AP13=$R13,$AT13=$R13,$BO13=$R13,$BV13=$R13,$CC13=$R13,$CG13=$R13),COLUMN($AE13:$HA13)))+16))

After:

=INDIRECT(
    ADDRESS(
        9,
        MAX(
            IF(
                OR(
                    $AE13=$R13,
                    $AL13=$R13,
                    $AP13=$R13,
                    $AT13=$R13,
                    $BO13=$R13,
                    $BV13=$R13,
                    $CC13=$R13,
                    $CG13=$R13
                ),
                COLUMN(
                    $AE13:$HA13
                )
            )
        )+16
    )
)