Excel Question

Discussion in 'OT Technology' started by XxRicanxX, Mar 5, 2007.

  1. XxRicanxX

    XxRicanxX New Member

    Joined:
    Sep 13, 2002
    Messages:
    3,119
    Likes Received:
    1
    Location:
    Boca Raton, FL
    I want to have a column that has "Number 1", "Number 2", etc... what do i do to where I can just drag the cell and it automatically does it?
     
  2. P07r0457

    P07r0457 New Member

    Joined:
    Sep 20, 2004
    Messages:
    28,491
    Likes Received:
    0
    Location:
    Southern Oregon
    what?
     
  3. kingtoad

    kingtoad OT Supporter

    Joined:
    Sep 2, 2003
    Messages:
    55,924
    Likes Received:
    11
    Location:
    Los Angeles
  4. XxRicanxX

    XxRicanxX New Member

    Joined:
    Sep 13, 2002
    Messages:
    3,119
    Likes Received:
    1
    Location:
    Boca Raton, FL
    i'm talking about the "Fill Handle"
     
  5. Coottie

    Coottie BOOMER......SOONER OT Supporter

    Joined:
    Jun 6, 2006
    Messages:
    32,407
    Likes Received:
    0
    Location:
    OKC
    straight from Excel help....inside the program:
     
  6. Slid.

    Slid. I'm a guy.

    Joined:
    Oct 25, 2001
    Messages:
    1,928
    Likes Received:
    0
    Location:
    NH
    You mean to AutoFill a formula down an entire column? Double-click the lower right-hand corner of the cell you want to replicate.
     
  7. jimbo_jones

    jimbo_jones New Member

    Joined:
    Aug 31, 2006
    Messages:
    124
    Likes Received:
    0
    Put a few of the values in the first few cells to establish the pattern and then highlight all of the cells and grab and hold the bottom right corner of the selected cells and drag until you have all the column filled as much as you need it to be.
     

Share This Page