Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

Shop online 24hrs a day or call us Mon-Fri
8:30AM-4:30PM EST - 1-800-915-2088
WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

Quicker Data Entry in Excel

Tuesday, September 29th, 2009 by | Filed Under: MS Excel
 
Loading...


I don’t know about you but I often find that when entering data into an Excel worksheet I’m frequently entering data at a rapid rate only to stop at the end of the column or row to move to the next.

For example, let’s say that I have information about customers such as name, address and phone number set up in columns A, B and C. I might then want to enter the actual data into rows 2 through 15.

After the first row of data I have to stop to go back to column A on the next row.

Enter data, stop, next row, enter data, stop… you get the idea and it’s a pretty frustrating situation.

I really don’t want to be bothered with all the starts and stops. Just let me enter the data efficiently without all the delays!

Well, today I have just the thing we need to move along at a pretty speedy rate.

The whole key is to select all the cells for data entry before starting.

To explain let’s return to the above example…

Before I begin entering customer information I would select a rectangular set of cells containing columns A through C and rows 2 through 15. (Start the selection with cell A2 in order to begin your data entry there.)

image

Now, with all the cells still selected, begin entering the data.

I found that I could use either the Enter key or the Tab key to move from one cell in the selection to the next. (Arrow keys remove the selection of the range so don’t touch those!)

The cool part is that when the cell selection reaches the edge of the selected area it will automatically return to the top of the next column or the first cell of the next row (based on the direction you are moving).

I enter a name, Tab, address, Tab, phone number, Tab and POOF!

I’m at the start of the next row ready for the next customer name without the need to navigate over there.

Oh… and as an extra FYI… when you get to the last cell of the selected area the cell selection will cycle back around to the top again. That’s a fact to keep in mind. You don’t want to be on a “roll” forget where you are and cycle back to the top and then accidentally overwrite data.

And, there it is, a simple way to make data entry as smooth as silk.

~ April

Leave a Reply


Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.


Enter Email Address:

Subscribe

Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup



Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Subscribe


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive


Categories:
Archives: