What is Excel AutoComplete feature in Excel? (Excel-2007)
Q. What is Excel AutoComplete feature in Excel?
Ans. Entering data in a worksheet can be time consuming. One of the tools that Excel provides to make entry easier is AutoComplete. When you start to type something in a cell, Excel tries to guess what you are typing and shows a "match" that you can accept simply by pressing Enter. The "matches" that Excel uses in its "guess" is nothing but the contents of the cells in the column, above where you are making your entry. For instance, if you have information in cells A1 through A6 and you are entering a value in cell A7, Excel looks at what you are typing. If the first few characters uniquely match something in any of the six cells previously entered in the column, then Excel offers to AutoComplete A7 with the contents of the cell that matched. Excel does not try to match with cells that contain only numbers, dates, or times. The cells must contain either text or a combination of text and numbers.
0 comments:
Post a Comment