+ Reply to Thread
Results 1 to 3 of 3

Auto Number After Inserting Row

  1. #1
    Registered User
    Join Date
    04-13-2009
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    94

    Auto Number After Inserting Row

    Hi guys, anybody can help me or giving me some idea on how to solve my problem.
    I'm trying to make a table with autonumbering even if i insert a new row it will automatically add numbering according to row number. i tried it using IF function but after inserting row i have to drag the formula down again. please see attach. thanks
    Attached Files Attached Files

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Auto Number After Inserting Row

    You can use
    =Row()

  3. #3
    Registered User
    Join Date
    04-13-2009
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    94

    Re: Auto Number After Inserting Row

    Quote Originally Posted by snb View Post
    You can use
    =Row()
    thanks. but how to automatically copy the formula without dragging the formula from top row?
    I mean after inserting row it will automatically make a number as per the row number

+ 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