What Is AutoComplete in MS Excel?

Save

AutoComplete in MS Excel is the guesswork provided by the Excel to match your text, based on previous entries you have made into the software. The AutoComplete function is meant to save you time and labor.

Concept

  • Consider that you have information in the Cell A1 through Cell A8. Now you are entering a value in Cell A9. At this point, Excel examines what you have been typing and, based on the contents of other eight cells, tries to auto complete Cell A9.

Significance

  • Using AutoComplete in MS Excel helps you save time and reduces the amount of text you have to enter. AutoComplete is a handy tool when filling a table with duplicate entries.

Limitation

  • AutoComplete halts its operation in MS Excel if there is a blank cell in the existing list. Excel will not provide the AutoComplete feature if the cells contain only numbers, dates and time.

Considerations

  • If AutoComplete starts to annoy you, it is easy to switch off this feature from the Tools menu in Excel.

Insight

  • AutoComplete serves you best if you are creating or editing formula in MS Excel by minimizing typing and syntax errors.

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!