Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 17th 04, 04:53 PM
the worker
 
Posts: n/a
Default 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   Report Post  
Old November 17th 04, 05:00 PM
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Old November 18th 04, 02:39 AM
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need to increase a number which is held in a cell by 1 Steve New Users to Excel 1 January 14th 05 01:07 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 08:18 AM
#VALUE in cell but pop up function box show right number Ted Dalton Excel Discussion (Misc queries) 1 December 14th 04 04:15 PM
cell that accepts a whole number or five place deciaml crck_whr Excel Worksheet Functions 2 November 12th 04 05:14 PM
returning a text cell based on a number cell Josh7777777 Excel Worksheet Functions 2 November 2nd 04 08:42 PM


All times are GMT +1. The time now is 02:13 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017