Friday, 5 December 2014

Use Line Breaks In Complex Formulas To Make Them Easier To Read in MS Excel with Example

How to break complex/Long Formulas into multiple lines to make them easier to Read in Microsoft Excel with Example.


Everyone know that in Excel, he/she can get very creative with formulas and do things most users would never have thought possible. There is one drawbacks with long, complex formulas that they are often difficult to understand - especially when a person go back and look at them long after they were originally created.

Break Split Formulas into multiple lines
Many people don't know this but you can make complex, long formulas easier to read by breaking them into smaller parts on separate lines. You can insert line breaks in your Formulas & Functions- just like you can insert line breaks in text in a cell.

Breaks Excel Formulas into Lines
To break the next part of the formula to a new line just simply press ALT + ENTER as you are
editing your formula. (If you're using a Mac, hold down the Option and Command keys while pressing Return).

Remember that the Formula Bar doesn't automatically adjust it's height to display formulas on two or more lines. To view your formula you can resize the Formula Bar. Just position your mouse pointer over the bottom edge of the Formula Bar and drag it down to see all of your formula. You'll also need to drag it back when you are finished.

Not only does this make the process of creating multi-step formulas easier, but also when you or someone else are viewing the formulas later, this will make them much easier to read and edit.



0 comments:

Post a Comment