A Quick MS Excel Tip: How to Deal with Long Formulas

If you are working with Microsoft Excel and you are a somewhat more advanced user you know the problem that you can lose yourself in your formulas.


If your formulas turn out longer than expected then you can use the quick key ALT+ENTER. If you use the combination ALT+ENTER after each formula section then you are able to break it up in pieces and follow the calculation and check it in your spreadsheet.


If you are a heavy MS Excel user this ALT+ENTER quickkey should be standard for all your calculations.