answersLogoWhite

0

EXCEL 2003: To turn AutoComplete on or off, follow these steps:

  1. On the Tools menu, click Options, and then click the Edit tab.
  2. To allow automatic completion, click to select the Enable AutoComplete for cell values check box. To prevent automatic completion, click to clear the check box.

EXCEL 2007: To turn off the Formula AutoComplete function, follow these steps:

  1. Click the Microsoft Office Button, click Excel Options, and then click Formulas.
  2. Click to clear the Formula AutoComplete check box.
  3. To turn it back on, reverse the process.
User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

Name a search function within Excel?

There is a function called FIND and a function called SEARCH in Excel. There are other functions that can be used to find things, such as the various lookup functions.


Which function is similar to the Find and Replace feature in excel?

the SUBSTITUTE function


What is used to locate a string in excel?

You can use the find command of the FIND function.


What is a function to find the number of values in cells?

In Excel is it COUNT.


What can be used to find an Excel function by typing a description of the formula?

You can use the Insert Function button fx on the Formula bar to find an Excel function by typing a description of the formula at the Insert Function dialog box, in the Search for a function text box and then click Go.


Will the Excel auto-sum function automatically find the sums of several columns in a range and put the currect sum below each column?

Yes, you can do that. If you have a series of columns, you can highlight all of the column to select the range. When you click on the auto-sum button, Excel will insert =SUM(XX:XX) at the bottom of each column in the range.


What Excel function finds the position of an item in a table?

The MATCH function can find the position of an item in a table.


Where do you find the Average function on Excel?

If you go to Insert Function, you will find it in the Statistical Functions category. You can also get it through the Autosum in versions from 2007 onwards.


Is there a function in Microsoft Excel where you can type a name or number you are searching for in the document and Excel will find it for you?

Try looking at SEARCH or INDEX in the help file.


Find the geometric mean 10 and 40?

Used the GEOMEAN function on Excel and the answer it gave was 20.


How can one user get full Microsoft Excel help?

Microsoft Excel has a help function built into it that will search through a pre-installed FAQ to help find an answer. If you cannot find an answer there Microsoft support can answer any question you have.


How do you access a previous saved document in Excel if it is not on system restore please?

Go to Open and look for the document. If it is not on the Excel list of previous documents, then Excel can offer you no help finding the document. Use the Windows search function to find the file, then open with Excel.