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

Lesson 3. Entering Data into the Workshe... > Entering a Series of Numbers, Dates,...

Entering a Series of Numbers, Dates, and Other Data

Entering a value series (such as January, February, and March or 1, 2, 3, 4, and so on) is accomplished using the Fill feature discussed in the preceding section. When you use the Fill feature, Excel looks at the cell holding the data and tries to determine whether you want to just copy that information into the adjacent cells or use it as the starting point for a particular series of data. For example, with Monday entered in the first cell of the series, Excel automatically inserts Tuesday, Wednesday, and so on into the adjacent cells when you use the Fill feature.

Sometimes, Excel isn't quite sure whether you want to copy the data when you use Fill or create a series. This is where the Fill options shortcut box comes in. It enables you to select how the Fill feature should treat the data that you have "filled" into the adjacent cells. Figure 3.6 shows the creation of a day series using Fill.

Figure 3.6. Fill also can be used to create a series of data in adjacent cells.


When you create a series using Fill, the series progresses by one increment. For example, a series starting with 1 would proceed to 2, 3, 4, and so on. If you want to create a series that uses some increment other than 1, you must create a custom series, which is discussed in the next section.

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