Enter a start number in a cell.
Right-click on that cell and drag down using the fill handle.
Release button and "Fill Series" from the menu.
OR.......enter a start number in a cell.
Select that cell and a whack of cells below.
EditFillSeriesOK
Gord Dibben Excel MVP
On Wed, 17 Nov 2004 07:53:03 -0800, "the worker" <the
wrote:
I am trying to find out how to increase the number, by the value of one, from
the cell directly above (without re-typing it in every time), and preferably
without entering a formula in every cell.