Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to renumber cells in Microsoft Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 24-01-2012
Member
 
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.

Reply With Quote
  #2  
Old 24-01-2012
Member
 
Join Date: Aug 2011
Posts: 563
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.
Reply With Quote
  #3  
Old 24-01-2012
Member
 
Join Date: Jul 2011
Posts: 618
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
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to renumber cells in Microsoft Excel"
Thread Thread Starter Forum Replies Last Post
Ignoring ranks when concatenating cells in Microsoft Excel New!life MS Office Support 2 23-02-2012 01:10 PM
How to avoid Microsoft Excel from automatically highlighting cells ELETTRA| MS Office Support 2 02-02-2012 03:43 PM
Not able to change font color in some cells of Microsoft Excel Garsen's MS Office Support 2 01-02-2012 01:08 PM
How to Manipulate cells in Microsoft Excel 2007 Deepest BLUE Windows Software 3 27-11-2009 01:48 AM
Short cut to merge cells in Microsoft Excel Jesus2 Windows Software 3 24-11-2009 05:31 AM


All times are GMT +5.5. The time now is 04:30 AM.