MS Excel help

El_Kabong
El_Kabong Posts: 4,141
edited August 2011 in Technical Stuff and Help
I can't believe I forgot this….in excel, say I want column A to be numbered like 1-100…instead of writing all 100 numbers you can make it number itself, but I forgot how…anyone know?
standin above the crowd
he had a voice that was strong and loud and
i swallowed his facade cos i'm so
eager to identify with
someone above the crowd
someone who seemed to feel the same
someone prepared to lead the way
Post edited by Unknown User on

Comments

  • BinFrog
    BinFrog MA Posts: 7,314
    put number one in cell A1, then drag down cell A1 to A100 but left clicking on the lower corner of A1 and dragging down. Make sure the column type is numeric. Otherwise you have to fill in A1-A3 with 1, 2 and 3 and then highlite all 3, then drag A3-->A100 as described above.
    Bright eyed kid: "Wow Typo Man, you're the best!"
    Typo Man: "Thanks kidz, but remembir, stay in skool!"
  • El_Kabong
    El_Kabong Posts: 4,141
    ohhhhh yeah, thanks! I had only 5 items, then today I needed to add around 50, I was forgetting to highlight 1-5 and only highlighting 5 which added '5' in all of em. Thanks again!
    standin above the crowd
    he had a voice that was strong and loud and
    i swallowed his facade cos i'm so
    eager to identify with
    someone above the crowd
    someone who seemed to feel the same
    someone prepared to lead the way
  • bostonlou
    bostonlou Posts: 2,849
    i love Vlookup
    Don't Believe Everything You Think
  • 81
    81 Needing a ride to Forest Hills and a ounce of weed. Please inquire within. Thanks. Or not. Posts: 58,276
    bostonlou wrote:
    i love Vlookup

    let me put a little fixer on that


    i love sumif
    81 is now off the air

    Off_Air.jpg

Categories