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

Posted on September 8, 2008 
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

  Here are a few posts the other readers recommend you check out.

Today extra’s Tip is a quick but useful Excel Tip. 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.

 

Do you want to see more? This is related...

Invite your friends to the World of Office.
Did you ever thought about publishing your own eBook or PDF report?
Invite your friends to the World of Office.
Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 3 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!


If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.





Comments

Leave a Reply