Wednesday, May 19, 2010

Speeding Up Spreadsheet "Excel" Data Entry

When you are using spreadsheet software, such as Excel, and have a lot of data entry work to do for your mailing list or budget - try to use your keyboard instead of reaching for your mouse.

Using the mouse, is the slow way of doing anything on a computer. It's fine if you have only a small amount of data to enter or if you're not in a hurry. To speed up your data entry use the keyboard. Below is a list of keys that you can use when you want to quickly enter your data.
  • Enter key: enters the data and moves the active cell highlight down to the next cell in the current column
  • Tab key: enters the data and moves the active cell highlight to the next cell in the current row
  • Arrow keys: enters the data and moves the active cell highlight to the next cell in the direction of the specific arrow key pressed. For example, if the up arrow is pressed, the active cell highlight moves up to the next cell in the current column
  • Esc key: cancels the current data entry

No comments:

Post a Comment