O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required