how to increase the number by 1 from the cell above?


G

Guest

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.
 
Ad

Advertisements

G

Guest

Hi
easy solution. Formula:
=A1+1
and just copy down as far as needed
 
Ad

Advertisements

G

Gord Dibben

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.

Edit>Fill>Series>OK

Gord Dibben Excel MVP

On Wed, 17 Nov 2004 07:53:03 -0800, "the worker" <the
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top