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

Chapter 23. 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 you define.

Because of its tremendous number of options, even Excel experts sometimes have trouble coaxing the correct results out of AutoFill. In general, using AutoFill will have one of the following results:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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