1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

excel qestion..

Discussion in 'Windows & Other Software' started by _Jimlad_, 1 Jun 2010.

  1. _Jimlad_

    Capodecina

    Joined: 5 Jun 2005

    Posts: 19,725

    Location: Southampton

    is there anyway i can populate the cells with numbers? - 1 - 700 ? i know they have numbers on the side but i need them cells too
     
  2. Ryan-3

    Sgarrista

    Joined: 14 Sep 2009

    Posts: 8,870

    Location: Northumberland

    You mean like:

    1
    2
    3
    4
    5
    6....

    If so, just type the first few, and then click the little black square, bottom right of the highlighted cell, and drag down to the desired number :)
     
  3. _Jimlad_

    Capodecina

    Joined: 5 Jun 2005

    Posts: 19,725

    Location: Southampton

    jees that easy lol

    cheers buddy
     
  4. Ice Globe

    Wise Guy

    Joined: 31 May 2006

    Posts: 1,132

    Location: Cheshire

    There is also the "Edit-Fill-Series" function which will work for dates and other formats.
     
  5. rickh

    Hitman

    Joined: 26 Dec 2008

    Posts: 613

    for a simple task like this, the above solution is easiest - but you should know how to use excel properly to get the most out of it

    excel formulas will allow you to do more complex things but also simple things like this:

    in cell a1 you write: 1
    in cell 2 you write: =a1+1
    you can then drag cell 2 all the way down
     
  6. hood1971

    Wise Guy

    Joined: 11 Apr 2003

    Posts: 1,281

    And dont forget to copy cells and paste special as values.
     
  7. Namsnik

    Gangster

    Joined: 27 Jan 2007

    Posts: 245

    Location: Bucks

    Well, if you want the numbers to adjust if you insert or delete rows then you might want to try (example formula in cell A4):
    =ROW(B4)