Remember Me?

#1
November 17th 04, 03:53 PM
 the worker Posts: n/a
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
November 17th 04, 04:00 PM
 Frank Kabel Posts: n/a

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
November 18th 04, 01:39 AM
 Gord Dibben Posts: n/a

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Steve New Users to Excel 1 January 14th 05 12:07 PM [email protected] New Users to Excel 2 January 6th 05 07:18 AM Ted Dalton Excel Discussion (Misc queries) 1 December 14th 04 03:15 PM crck_whr Excel Worksheet Functions 2 November 12th 04 04:14 PM Josh7777777 Excel Worksheet Functions 2 November 2nd 04 07:42 PM

All times are GMT +1. The time now is 08:12 PM.