AutoComplete Feature in Microsoft® Excel® 2003
Do you want to know about the use and benefits of AutoComplete feature in Microsoft Excel 2003?
Microsoft Excel 2003 includes a time saving feature called AutoComplete. When you are typing a list in Excel, this will often suggest an item from a previous one entered, if they appear to be similar. If you were typing in the month of the year, when you type in the month of May, it will suggest March for you. With only the month typed, if you press the return key, it will automatically put March for you. The AutoComplete feature can be useful when you are typing a list that has a lot of replication in it. When you are typing a formula, Microsoft Excel 2003 can help you to show the different components in similar facility. Microsoft Excel 2003 does not try to match with cells that contain only number, times or dates. The cell must contain either text or the combination of text and numbers.
Let us now talk more about the AutoComplete feature in Microsoft Excel 2003:
- Time saving
Compare the text that you are currently typing into a column in the sheet and AutoComplete feature will complete the text for you. The list comes from the previous rows with no blank ones. First, you have to right click and using pick from drop down list you will get similar results. If the AutoComplete feature is not working, you have to choose 'Tools', then 'Options' and 'Edit' tab. Make sure that the 'Enable AutoComplete for the cell values' is checked.
The AutoComplete feature initiates when you start typing something that you have written before. It will offer you to auto fill with a past word. Alternately, you can right click and select ‘pick from drop down list’, it will offer you all the words used before in that column in Microsoft Excel 2003.
AutoComplete feature can save your time when you are entering a lot of similar data in a column. This is one of the better options in Microsoft Excel 2003. If the first few characters uniquely match something in any of the six cells previous entered in the column, then Microsoft Excel 2003 automatically completes the text for you which saves a lot of time.