Excel Data and Formula Entry Tips

Speeding up data entry

There are number of shortcuts you can use to speed up your data and formula entry in Excel.

Number keypad

Use the number keypad on the right of the keyboard. This has all the numbers, as well as most of the formula operators (+  * –  /), you need to create formulas. It also has a large Enter key. The numbers are laid out like a calculator and so are easy to use.