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

Turn Off Excel AutoComplete

Monday, March 22nd, 2010 by | Filed Under: MS Excel
 
Loading...


I’m sure that anyone who works in MS Excel has noticed that it has a habit of trying to finish a piece of data for you.

Excel likes to think of that habit as helpful and it’s called AutoComplete.

Well… I can admit that there are select times when it can be helpful but I’ve got to say that for the Excel work I do it gets to be a bit of a pain.

Sometimes I end up with data I never wanted because I didn’t realize that Excel was trying to AutoComplete with something wasn’t a match.

When you’re in that situation the only thing you can wonder is how to prevent it from happening again.

Fortunately it’s an easy fix, just a single setting in Excel’s options and you’re free of the problems AutoComplete can cause.

So, here’s the plan:

First we need to get to the correct location in Excel’s Options dialog box.

– In older versions of Excel you’ll find it under the Tools menu, Options choice. From there we need the Edit tab.


- Excel 2007 users need to go to the Office Button and click the Excel Options button in the bottom right corner. From there we need to proceed to the Advanced Options category.

At this point everyone is looking to uncheck the “Enable AutoComplete for cell values” entry.

Once the checkbox is cleared click OK.

And that should do it. From now on you’ll have only the data that was actually entered into each cell, no more of Excel’s suggestions and no more incorrect data… well at least that we can contribute to AutoComplete’s behavior.

~April

Comments are closed.

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: