Microsoft Excel 2013 – Fill Cells with a Series by Using the Fill Handle – Level:Beginner

Fill cells with a series by using the fill handle

  1. Select the first cell in the range that you want to fill.
  2. Type the starting value for the series.
  3. Type a value in the next cell to establish a pattern.

For example, if you want the series 1, 2, 3, 4, 5…, type 1 and 2 in the first two cells. If you want the series 2, 4, 6, 8…, type 2 and 4. If you want the series 2, 2, 2, 2…, you can leave the second cell blank.

  1. Select the cell or cells that contain the starting values.
  2. Drag the fill handle Selected cell with fill handle across the range that you want to fill.

To fill in increasing order, drag down or to the right. To fill in decreasing order, drag up or to the left.

About Dennis Strain

Microsoft Office 365 Sales & Support Specialist - Managed Computer Services Provider
This entry was posted in Excel 2013, How-To, Microsoft. Bookmark the permalink.

One Response to Microsoft Excel 2013 – Fill Cells with a Series by Using the Fill Handle – Level:Beginner

  1. Nice excel tips. Are you experiencing youtube channel just for this tutorial? When you have video tutorial, it would be great mate 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *