how do I autofil a column with sequential numbers?

[Yesrek]

[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)

[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

On Sat, 19 Nov 2005 14:48:04 -0800, Yesrek <[email protected]>
wrote: