Tuesday, October 9th, 2007

Quickie calculations in Word 2003

Older versions of Word included a Calculate option on the Tools menu which let you make quick calculations.

If you’re using Word 2003 you can add the tool back by right clicking any toolbar and choose Customize. Select the Commands tab and, from the Categories list choose All Commands and scroll the Commands list to locate ToolsCalculate. Drag this onto the Tools menu and hold your mouse there until the menu opens and then drop the option into place. If desired, right click the new entry and remove the word Tools from its name so it simply reads Calculate.

Now test your new menu item by typing some values eg 24, 25 & 26 and select them. Choose Tools, Calculate and the status bar will display “The result of the calculation is 75”. If you later click Control + V you can paste the result of the calculation (75) into your document.

To sum a column of numbers, hold Alt as you drag over the column with your mouse then choose Tools, Calculate. It also works inside tables and you can type a more detailed calculations such as 25*25 and it will calculate the result for you (answer: 625)

So, put away the calculator and let Word to the work for you.

Helen Bradley

Friday, August 17th, 2007

Status bar functionality – Excel 2007

Right click the Status Bar in Excel 2007 and an entire grab bag of options open up for your choosing. You probably already knew that you could configure Excel in earlier versions to show you a single calculation on a selected range of cells – so you could select cells and then read the Sum of the values on the Status Bar (you did know that didn’t you?) but the functionality is even better in Excel 2007.

Here you can choose to view an entire range of calculations so, instead of being forced to choose between Sum and Average you can have both display and throw in Min, Max and Count for good measure too!

You can also add a Macro Record button to use to fire off the Macro recording tool without having to delve into the ribbon to do so.

It all adds to your very slim customization pickings in Excel 2007 – make the most of it, this and the Quick Access toolbar are about all you’ve got to play with.

Helen Bradley

Sunday, January 28th, 2007

Quick Calculations in Word
Older versions of Word included a Calculate option on the Tools menu which let you make quick calculations.

You can add it back into later versions of Word by right clicking any toolbar and choose Customize. Select the Commands tab and, from the Categories list choose All Commands and scroll the Commands list to locate ToolsCalculate. Drag this onto the Tools menu and hold your mouse there until the menu opens and then drop the option into place. If desired, right click it and remove the word Tools from its name so it simply reads Calculate.

Now test it by typing some values eg 24, 25 & 26 and select them. Choose Tools, Calculate and the status bar will display “The result of the calculation is 75”.

If you later click Control + V you will paste the result of the calculation (75) into your document.

To sum a column of numbers, hold Alt as you drag over the column with your mouse then choose Tools, Calculate. It also works inside tables and you can type a more detailed calculations such as 25*25 and it will calculate the result for you (answer: 625)

Helen Bradley