Create a series of numbers
To create a series of numbers in a spreadsheet column, follow these instructions:
- Type the first number of the series into a cell. For this example, say we enter a number into cell D9.
- One cell below this, enter the formula, =D9+1 or =D9-1, depending on whether you want the series to increase or decrease. Replace "D9" with the cell in which you entered the first number, and "1" with whatever number you'd like the series increased/decreased by.
- Select the cell into which you entered the formula, and click the small blue square in the lower-right corner of the cell. Drag your mouse down until the selected number of cells is highlighted.
- Once you have highlighted the desired column of cells, click Ctrl+D. A series of numbers will now be created in the selected cells.
Matt is a Docs & Drive expert and author of this help page. Leave him feedback below about the page.