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. |
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. |
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. |
All times are GMT +1. The time now is 01:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com