The Fill handle and SpeedFill can also be used to complete a series. Place the number 1 in cell A1, the number 4 in cell A2. The remaining cells will fill in the appropriate values based on the series that was given. The difference between each of the cells will be the values to increment or decrement by. The series shortcut works with numbers, months and dates, and even values like 1st, 2nd, 3rd, etc.
More complex series are available through built-in functions.
This page maintained by the Office of Information Technology Help Desk.