+ Reply to Thread
Results 1 to 3 of 3

Autonumber

  1. #1
    Registered User
    Join Date
    06-07-2008
    Posts
    31

    Autonumber

    Hi,

    Im using excel 2007. I have a table that i was 1 column to autonumber down the left side, which if you insert a row rejigs the numbers accordingly.

    Is this possible.

    Many Thanks in advance.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    If you want the number 1 to appear in the first row of the spreadsheet, =row() and copy down.

    If you want 1 to appear on, say, row 5, then =row() - 4 and copy down.

  3. #3
    Registered User
    Join Date
    06-07-2008
    Posts
    31
    This worked great, although its now extended further. When i inserted a row it automatically autonumbered. Great.. but i now need it to insert a letter next to the number. i.e...

    rows 1-10 numbered 1-10. If i insert a row at line 5, i need it to call it row 4a then 4b etc.

    Is this possible?

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1