60-Second Skills: Cleaner Presentation Of Long Formulas For Ease Of Understanding And Auditing

Problem: Long, multi-part formulas can be tough to digest and challenging to audit when they extend a long way across the formula bar, or wrap onto multiple lines based solely on the available screen real estate.

REFM 60-Second Skills Solution: Separate your formula parts visually on separate lines within the formula bar (and drag down the bottom edge of the formula bar to view the multiple lines) by creating multiple line breaks in between formula logic arguments using Alt+Enter where you wish to insert a new line in how the formula appears (in the example below we held down Alt, and while keeping it held down, hit Enter after the first comma, after the second comma, and before the asterisk).