O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

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

Automatically Filling In a Series of Data

One common and tedious data-entry task is entering a sequence of numbers or dates in a column or row. Excel's AutoFill feature can handle this chore automatically by filling in information as you drag the mouse along a column or row. Use AutoFill to copy formulas or values; enter the days of the week, months of the year, or any series of numbers or dates; and even fill in custom lists of departments, category names, part numbers, and other information that you define.

Because of its tremendous number of options, even Excel experts sometimes have trouble coaxing the correct results out of AutoFill. The addition of Smart Tags in Excel 2002 makes this task somewhat easier. If using AutoFill has the wrong ...

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