Results 1 to 3 of 3
  1. #1
    Super Sh!t Stirrer SSanf's Avatar
    Join Date
    January 18th, 2005
    Posts
    9,944
    Excel expert?
    I would like to number the rows on my spread sheet. Anyone know how?

    For instance, I would like A1 to read 1
    A2 to read 2
    A3 to read 3

    and so forth.

    Can I do this fast?
    Comments are opinion unless otherwise noted. Remember, pillage first. Then burn. Half of all people in the world have IQs under 100. You best learn to trust ol' SSanf!

  2. #2
    Merchant Linda's Avatar
    Join Date
    January 18th, 2005
    Location
    TN, USA
    Posts
    1,030
    This what you're looking for?

    Physically type 1 in A1
    In A2 cell, type =A1+1
    Then copy the A2 cell and paste down as far as you want to number

  3. #3
    Super Sh!t Stirrer SSanf's Avatar
    Join Date
    January 18th, 2005
    Posts
    9,944
    Thanks!

    Made my day.

    Now, I can be such a show off!
    Comments are opinion unless otherwise noted. Remember, pillage first. Then burn. Half of all people in the world have IQs under 100. You best learn to trust ol' SSanf!

  4. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Need Help with Excel
    By Rhea in forum Programming / Datafeeds / Tools
    Replies: 8
    Last Post: June 1st, 2005, 04:32 AM
  2. Excel question
    By netsu in forum Midnight Cafe'
    Replies: 2
    Last Post: January 31st, 2004, 07:31 PM
  3. Excel Question
    By ~Michelle in forum Midnight Cafe'
    Replies: 2
    Last Post: January 21st, 2004, 02:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •