+ Reply to Thread
Results 1 to 4 of 4

Auto Numbering in a column

  1. #1
    Registered User
    Join Date
    05-24-2014
    Posts
    4

    Auto Numbering in a column

    i want to enter a row is a serial number column and wanted if any row is inserted all the numbers are still in a serial number for example.

    1
    2
    3
    4
    5
    6
    7

    this is a original sequence column.now what i want to do is

    1
    2
    3

    4
    5
    6
    7
    a row is inserted and i want to enter a number in the cell so that all the numbers in the column are still in sequence

    Please reply it is urgent

    Thanks & Regards,
    Deeppak

  2. #2
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Auto Numbering in a column

    Hi,

    Welcome to the forum

    Try this:
    In cell A2 enter: =ROW()-1
    Autofill down
    Insert a row
    Autofill the value just above the inserted row
    All values update
    Regards,
    Rudi

  3. #3
    Registered User
    Join Date
    05-24-2014
    Posts
    4

    Re: Auto Numbering in a column

    thanks it solved the problem

  4. #4
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Auto Numbering in a column

    Great. Good to know...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto Numbering a Column
    By suttercain in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-14-2007, 06:01 PM
  2. [SOLVED] Auto Numbering Each Cell In A Column
    By UFWPresident in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-16-2005, 08:05 PM

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