How to Create Sequential Numbers on an Excel Document With Software

Written by matthew burley
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Create Sequential Numbers on an Excel Document With Software
(Stockbyte/Stockbyte/Getty Images)

Microsoft Excel is a spreadsheet application that is part of the Microsoft Office program suite. Users can store and manipulate data inside a table-like grid, which can then be sorted and compared in numerous ways. Additionally, Microsoft Excel is capable of providing a user with automation based off of patterns and cell associations. For example, it is possible to select a group of cells and populate them with a list of sequential numbers based off of an existing pattern.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

  1. 1

    Type the first number of your sequence into the cell corresponding to the top position of your list. For example, if you wanted to start your numbering sequence in the top left corner of the spreadsheet, you could type "1" into cell "A1."

  2. 2

    Type the second number of your sequence into the cell corresponding to the second position of your list. For example, you could type "2" into cell "A2." Add more numbers to your sequence if the numbering pattern isn't recognisable after two numbers.

  3. 3

    Click on the top cell in your sequence and drag your mouse to select the rest of your starting values.

  4. 4

    Click the "fill handle" in the bottom right corner of the bottom cell, then drag the handle down until all of your required cells are included within the selection. For example, if you entered "1" and "2" into cells "A1" and "A2" respectively and wanted to create a 20-number sequence, you would drag the handle to cell "A20."

  5. 5

    Release the left mouse button to fill your selected cells with a list of sequential numbers.

Tips and warnings

  • If you are creating a list of sequential numbers in Excel that is not consecutive, and Excel is not recognising the pattern, then manually add more numbers until Excel understands the pattern.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.