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

Entering a Series with AutoFill > Entering a Custom Series

Entering a Custom Series

Although AutoFill is good for a brief series of entries, you may encounter situations in which you need more control. Excel can handle several different types of series, as shown in Table 5.2.

Table 5.2. Data Series
SeriesInitial EntriesResulting Series
Linear1,21, 2, 3, 4
100,99100, 99, 98, 97
1,31, 3, 5, 7
Growth10, 2010, 20, 30, 40
10, 5010, 50, 90, 130
DateMon, WedMon, Wed, Fri
Feb, MayFeb, May, Aug
Qtr1, Qtr3Qtr1, Qtr3, Qtr1
1992, 19951992, 1995, 1998



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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