Helpful Tips Blog

All Tips

How do you use SUM() in VBA?

Here’s an example where you know the exact range you want to sum, as in the following illustration. To add Sum functions for columns F and G use the following code: Sub SumExample1() Range("F15").Value = WorksheetFunction.Sum(Range("F2:F14")) Range("G15").Value =...

read more

Using Extend Selection Mode in Word

Extend Selection Mode is a keyboard method of anchoring the cursor before you select text. Pressing F8 turns it on and and pressing any arrow keys at that point will select text from the anchor point in that direction. In the following illustration the anchor point is...

read more

Conditional Statistics in Excel

If you're an Excel user, you've probably used the SUM function. It's fairly simple. The following formula returns the sum of all values in the range of cells in Column A from rows 4 through 1799: =Sum(A4:A1799) Sometimes you need to sort your data before you can get...

read more

Excel Legacy Shortcuts

The following table is a list of Alt-Key shortcuts that still work with current versions of Excel. File Menu Alt+F New Alt+F-N Open Alt+F-O Close Alt+F-C Save Alt+F-S Save As Alt+F-A Print Preview Alt+F-V Print Alt+F-P Send To Alt+F-D Edit Menu Alt+E Undo Alt+E-U Cut...

read more