| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to increase the number by 1 from the cell above?
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. |
|
#2
|
|||
|
|||
|
Hi
easy solution. Formula: =A1+1 and just copy down as far as needed "the worker" 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. |
|
#3
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to increase a number which is held in a cell by 1 | New Users to Excel | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| #VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
| cell that accepts a whole number or five place deciaml | Excel Worksheet Functions | |||
| returning a text cell based on a number cell | Excel Worksheet Functions | |||
Linear Mode
