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
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."
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.
Click on the top cell in your sequence and drag your mouse to select the rest of your starting values.
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."
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for