Automating Your Work

Although the design and set up of an Excel workbook can be exciting, the data entry portion—the grunt work—can be dull. Few people like to sit at their computers and type the same information again and again. Entering consecutive dates or numbers can cause your mind to wander. Fortunately, Excel has some tools to help you automate your data entry.

AutoComplete Speeds the Entry Process

As you create your worksheets, you'll probably find that you enter the same text over and over. Typing repetitive text is boring and, because you might not be paying close attention, increases your chances of making a typing mistake. Fortunately, Excel has a feature called AutoComplete to automate the entry of text you type multiple times.

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours 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.