Several methods for this.

Easiest is to enter 102876 into a cell.

Hover the mouse pointer over the right bottom corner of the cell until the
white cross changes to a small black cross.

RIGHT-click on fill handle(small square lump)and drag down the column.
Release and select "Fill Series"

Next easiest is to enter 102876 in a cell then 102877 in cell below. Select
both these cells and drag/copy down the column using the fill handle.

Then there is EditFillSeries which is the most cumbersome for this
operation.

Gord Dibben Excel MVP

On Fri, 23 Jan 2004 19:37:54 -0600, Beesht
wrote:

I have a number in a column cell which is 102876.
Is there a way to automatically copy this number into other cells in
the column but add 1 at the same time.
So if I have 102876 in the 1st column cell, the 10th one would be
102886.
Thanks


---
Message posted from http://www.ExcelForum.com/