How to create a range of numbers in Excel – 3 easy ways

This is all the range these days...

Microsoft Excel logo featuring numbers and a pink background.

You can trust PC GuideOur team of experts use a combination of independent consumer research, in-depth testing where appropriate – which will be flagged as such, and market analysis when recommending products, software and services. Find out how we test here.

Last Updated on

If you’re wondering how to create a range of numbers in Excel, we’ve got you covered right here with a few methods you can use.

Here’s the example we’re using for this guide. A list of states in a table.

As you can see, the States are in Column B and space for a list of different Ranges in Column A. For this example, let’s say we want to quickly create a range of numbers for the list of States

A screenshot of a table

Description automatically generated

Method 1 – Using the FILL function

In this method, we will use the FILL function to create a range of sequential numbers in Excel.

  • Enter the first 2 numbers in the sequence in the first 2 rows as shown below. For this example, we will place the numbers 1 in cell A2 and 2 in cell A3.
A table with numbers and names

Description automatically generated
  • Next, we will place the cursor over cells A2 and A3 as shown below.
A screenshot of a spreadsheet

Description automatically generated
  • Next, we will hover over the edge of the green box until a plus sign appears on the right, bottom corner as shown below.
A screenshot of a spreadsheet

Description automatically generated
  • Then we will double-click the plus sign to create a sequential range of numbers as shown in the video below. 

Method 1 applies to any sequence of numbers you prefer, for example, if you prefer to have the sequence multiplied by six each time, simply start with two numbers in a six-digit interval as shown in the video below. 

Method 2 – Using the RANDBETWEEN function.

In this method, we will use the RANDBETWEEN function to create a random range of numbers in Excel.

Steps:

  • Select the cell you want the first number to appear. For this example, the cell will be A2.
  • Enter the function = RANDBETWEEN then select the lowest and highest number in the count of the States list in Column B, which will be the numbers 1 and 9. Add numbers 1 and 9 in parenthesis to the RANDBETWEEN function as shown below. 
A screenshot of a spreadsheet

Description automatically generated
  •  Then we will double-click on the plus sign to create a random range of numbers as shown in the video below. 

Method 3 – Using the SERIES function.

In this method, we will use the SERIES function to create a specified sequence of numbers in Excel.

Steps: 

  • Select the cell you want the first number to appear. For this example, the cell will be A2.
  • Enter the number you want to start the sequence with. For this example, the number will be 1. 
  • From the Home tab, select the SERIES function from the Home tab’s Editing section.
  • Ensure both Column and Linear are selected.  
  • Then select the number sequence of your choice. For this example, the sequence should increase by 3 until the number reaches 25. Therefore, 3 should be entered in the step value box and 25 should be entered in the stop value box and select OK as shown below.
A screenshot of a computer

Description automatically generated
  • To review the steps for Method 3 again please watch the video below.

Conclusion 

So there you have it, three different methods to create ranges of numbers in Excel. For more tips, tricks, and guides to everything Excel, be sure to check back in with us soon.

Ramzi Musa is a Growth Manager and Editor for BGFG. He has experience and expertise in tech, gaming, and hardware.