• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 25. Working with Lists and Datab... > Automatically Filling In a Series of...

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 result, click the AutoFill Smart Tag to see a list of other options that enable you to select a different result, such as changing a simple copy to a series.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint