Calculating in Excel Without Using Formulas.

Posted on March 21, 2008
Filed Under Excel Tips & Tricks

Where closing the week with a pretty cool Excel Tip & Trick. Excel spreadsheets can be really complicated when you are working with many formulas at a time. I try to cut back on all formulas because it’s just too complicated to work with. Fortunately there’s a quick way to display formulas in the Excel status bar.

For quickly showing the results of the Excel formulas you’ll need to follow the next steps.

· Type some random data in Cells A1 through A10.

· Select all the Cells

And as you can see, Excel 2007 shows 3 values which are Average, Count and the Sum of all numbers.

Excel-tip-trick-pic1

What you can also do is right click on the status bar and select other standard values. This way you’ll customize Excel to your likings and needs.

Excel-tip-trick-pic2

In Microsoft Excel 2007 the status bar is a standard tool to work with but I don’t know for sure if this is the same for the previous Excel versions. If you can’t see the status bar (the small bar between a workbook and the Start menu) in the previous Excel versions then you’ll need to go to Tools, Menu and select options. Then go to the view tab and select the Status bar check box.

So, I hope you’ve learned something this week and I’ll see you all next week with a whole pile of new Tips and Tricks for Vista, XP and Office. Have a great weekend!!

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

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.