Tip of the week # 582
2 September 2019

Faster way to enter a formula using the numeric keypad (Microsoft Excel) *

This tip is particularly helpful for those of you who can touch-type on the numeric keypad, as it can speed up the way you enter a formula into a worksheet.

Here's how:

  1. Select the cell in which the formula is to appear.
  2. Press + (the plus sign) on the numeric keypad.
  3. Use the arrows on the numeric keypad to move to the cell you want to include in the formula.
  4. Use the multiply, divide, add or subtract keys on your numeric keypad.
  5. Use the arrows to move to the other cells you want to include in the formula.
  6. Press ENTER.

If you don't have a numeric keypad or - like me - "hunt and peck" on that part of the keyboard the normal way of starting the formula with an equal sign and clicking on cells will do just fine.


* Unless stated otherwise, these tips were written for Microsoft Office 2010.