📞 01223 214177 ✉️ karen@roem.co.uk
If you work with numbers in a table you can perform calculations such as add, subtract, multiply and divide. The most common table calculation, I feel, is calculating the total of numeric entries in a column or row.
Here's how:
So what if you have more columns or rows and want to repeat the calculation? Well, why not use the repeat key. Which makes me realise I've never told you about the repeat key, have I? So this is this week's bonus tip ... F4 is the repeat key in Word, Excel and PowerPoint and simply repeats the last action you performed. Whether you changed the font, centered the text or totalled the entries in the column of your table, F4 will repeat the action.
By the way, when you modify any of the numeric entries, the total isn't automatically updated, like in Excel. You'll have to select the out-of-date total and press F9, or right-click it and select Update Field.
.
I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.