Microsoft® Excel® 2010 Autocomplete Function

To bring in more enhanced attributes, an Autocomplete formula has been added to Microsoft Excel 2010. It gives more efficient processing of data in worksheets. It also helps in making formulas with ease.

• How does it work?
• Benefits of Autocomplete
• Using Autocomplete

How does it work?

Auto complete function in Excel 2010 helps in making formulas more quickly. The Autocomplete formula has been designed to bring in items and formulas that match with the users input. Autocomplete drop down appears as soon as a letter is type in after putting in a ‘=’ symbol in a cell. The formulae from the dropdown can be inserted by double clicking on it. It helps the users to quickly identify the formula and also give options of formula which could be used. It just does not contribute in bringing the formula but also brings in the format of the formula so that the user can put in the parameters correctly. It prevents user from typing in more. The users are no longer required to remember formulas but can choose from the Autocomplete drop down list. Autocomplete function can be of great help for people. But for those it is undesirable, the Autocomplete feature can be turned off and on as and when required.

Benefits of Autocomplete

As Autocomplete formula has a library of all the formulas used in Excel 2010, there will not be any need of typing any formula manually. The formula will appear as soon as the keyword is typed. There is no need of memorizing the formulas either. User defined functions can also be used in Autocomplete. User do not need to remember the format, instead the Autocomplete feature brings in the format of the formula. It is easier as the user does not need to type in the complete formula. The computation time can also be saved in by using Autocomplete function.

Autocomplete feature is not just used in formulas, but is also used for texts which are used for the next time in another cell. It will bring in the text thus preventing the probability of error and ensuring less effort to the user. It has the ability to automatically create copies of the similar information inserted. Every alike and previous entry repeated comes in beforehand. However, users who do not prefer to use Autocomplete feature can disable it. To disable it click on Excel options button and click on advanced. Under editing options, uncheck ‘Enable Autocomplete’ and click on ‘OK’.

iYogi is the fastest growing online and remote tech support provider in the direct-to-consumers and small businesses sector. Our highly skilled and experienced tech experts available, 24x7x365 will provide the best issue resolution and customer satisfaction.

• Comprehensive technical support for using Autocomplete feature in Excel 2010
• Diagnosis & repair for your technologies
• Troubleshoot software errors
• Update drivers and security to protect against online threats
• Connect to Internet, devices and peripherals
• Optimize your computer’s speed and performance