See all How-To Articles

How to Make a List of Numbers in Excel & Google Sheets

This tutorial demonstrates how to make a list of numbers in Excel and Google Sheets.

 

autofill numbers series excel 1

 

AutoFill Numbers

Say you have data in two columns in Excel. In Column C, there are names, while in Column B, you want to assign a number to each name, i.e., make a list of numbers in Column B.

 

list of numbers initial data 1

 

Double-Click the Fill Handle

You can use AutoFill, by double-clicking, to populate cells based on the adjacent columns (non-blank columns to the left and right of the selected column). In this case, numbers will be populated through Row 9.

1. Enter 1 in cell B2. This is the initial data for Excel to recognize the pattern for AutoFill functionality.

2. Position the cursor in the bottom right corner of cell B2, and double-click the fill handle (the little black cross that appears).

 

autofill numbers fill handle 1

 

3. Click on AutoFill options and select Fill Series. Consecutive numbers are automatically populated through cell B9.

 

autofill numbers fill series 1

 

Fill Command

The above example could also be achieved using the Fill command on the Excel Ribbon.

1. Select the range of cells – including the initial value – where you want numbers populated (B2:B9). Then, in the Ribbon, go to Home > Fill > Series.

 

autofill series ribbon 1

 

2. In the pop-up screen, leave the default values: The column should be populated, and the Step value (increment) is 1. Press OK.

 

autofill series ribbon 2a

 

You get the same output: Numbers 1–8 fill cells B2:B9.

 

autofill numbers series excel 1

 

AutoFill Numbers in Google Sheets

You can also autofill numbers by double-clicking the fill handle (or just dragging it) in Google Sheets. Unlike Excel, Google Sheets need at least two numbers in order to be able to recognize a pattern.

1. Enter 1 in cell B2, and 2 in cell B3. This is the initial data for Google Sheets to recognize the pattern for autofill functionality.

 

google sheets autofill numbers fill handle

 

2. Select cells B2 and B3, position the cursor in the bottom right corner of cell B3, and double-click the fill handle (the little black cross that appears).

 

google sheets autofill numbers fill handle final

 

As a result, a list of consecutive number is filled in Column B.