Results 1 to 3 of 3

Thread: How to renumber cells in Microsoft Excel

  1. #1
    Join Date
    Nov 2011
    Posts
    100

    How to renumber cells in Microsoft Excel

    If I put numbers in Column A (1, 2, 3 etc.) and then I will have to remove various rows from Column A (#10, #15, #34, #45 etc.) can I get Column A to automatically renumber in sequence after I remove various rows.

  2. #2
    Join Date
    Aug 2011
    Posts
    568

    Re: How to renumber cells in Microsoft Excel

    You can use the Row() function to determine the row that the formula is in. Using an offset such as =row() + 3 will allow you to get the numbering you want. Note however that row() is a volatile function and if you have thousands of these functions you could adversely affect performance.

  3. #3
    Join Date
    Jul 2011
    Posts
    627

    Re: How to renumber cells in Microsoft Excel

    That is really not a big deal. Just click on the cell edge and drag or doubleclick. You can also drag by selecting two cells. Or esle you can se automatic numbering for Excel cells. So that whenever you remove any row it will re-number all stuff back. Just visit the below link and follow the instructions. You will find the process.

    Automatically number rows

Similar Threads

  1. Ignoring ranks when concatenating cells in Microsoft Excel
    By New!life in forum MS Office Support
    Replies: 2
    Last Post: 23-02-2012, 01:10 PM
  2. Replies: 2
    Last Post: 02-02-2012, 03:43 PM
  3. Replies: 2
    Last Post: 01-02-2012, 01:08 PM
  4. How to Manipulate cells in Microsoft Excel 2007
    By Deepest BLUE in forum Windows Software
    Replies: 3
    Last Post: 27-11-2009, 01:48 AM
  5. Short cut to merge cells in Microsoft Excel
    By Jesus2 in forum Windows Software
    Replies: 3
    Last Post: 24-11-2009, 05:31 AM

Posting Permissions

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