how do I autofil a column with sequential numbers?

B

Bryan Hessey

Put your starting number in a cell, then hold the CTRL key and
formula-drag the cell over the required range
(that is, highlight the cell, and click the small + in the bottom
right corner of the highlight, and drag this whilst holding the CTRL
key)
 
G

Gord Dibben

Two methods...there are more.

1. Enter your start number in A1

Select the entire column and Edit>Fill>Series>By Columns

Step value 1 and put in an end number and OK.

2. Enter 1 in A1 and right-click on fill handle(black lump on bottom right
corner of cell)and drag down column A as far as you want then release mouse
button and select "Fill Series".


Gord Dibben Excel MVP
 
Top