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

Lesson 9. Entering Different Types of Da... > Entering a Series of Numbers, Dates,...

Entering a Series of Numbers, Dates, and Other Data

Entering a series (such as January, February, and March or 1998, 1999, and 2000) is similar to filling a cell's contents. As you drag the fill handle of the original cell, Excel analyzes the first entry and creates a series of entries based on it. For example, if you type Monday in a cell, and then drag the cell's fill handle over some adjacent cells, you'll create the series Monday, Tuesday, Wednesday…. As you drag, the bubble lets you know exactly what you're filling so that you can stop at the appropriate cell to create exactly the series you want.

If you're filling a number, a month, or other item that might be interpreted as a series (such as January, February, and so on), and you don't want to create a series—you just want to copy the contents of the cell exactly—then press and hold the Ctrl key as you drag the fill handle.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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