Speeding Up Repetitive Data Entry with AutoComplete
Excel's default setup enables an option called AutoComplete, which is designed to speed up entering data in lists. As you type, Excel compares each character that you enter with other entries in cells directly above the active cell. If the opening characters match those of any other entry, Excel assumes that you want to repeat that entry and fills in the rest of the label. (This comparison applies only to cells that contain text; AutoComplete ignores numbers, dates, and times.)
If you want to repeat the previous entry, press Enter (or Tab or any arrow key) to insert the AutoComplete entry in the cell. Keep typing to enter a new value in the cell. Excel will not suggest an AutoComplete entry ...
Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
