Auto number in excel cells Tags: Excel Windows 7 Last response: October 2, 2012 4:38 PM in Windows 7 Share nisar4u October 2, 2012 2:38:53 PM Dear all, I have numbers e. g. 1 to 100 in excel in a particular column. If I remove any number e. g. 13 & keep that cell blank. Further cells should get automatically numbered from 13 onwards. Thanking all & hope to get answer. More about : auto number excel cells dextermat a b $ Windows 7 October 2, 2012 2:50:55 PM Hi, So what I understand is that you start from cell 1 and put 1 in there, in the 2nd cell it would be 2 (so you type the 1 number (1 and write "=A1+1") then copy to next cell. once you get to number 13, erase it and in the next cell write "=A12+2"), then in next cell write the formula mention above. This should give you what you want. I can send you an example if you need one just write me a personal message m 0 l ex_bubblehead a b $ Windows 7 October 2, 2012 2:57:12 PM Looks suspiciously like a homework assignment. OP, post your code and we'll critique and give pointers but we will not do your homework for you. m 0 l Can't find your answer ? Ask ! Get the answer 13thmonkey a b $ Windows 7 October 2, 2012 4:38:05 PM sounds to me like you want to insert a cell at A13 and push cells down, it would look just like deletion and the numbers continuing but it would be done by a different way. m 0 l Can't find your answer ? Ask ! Publish Related resources How to create an empty cells in excel file Forum Auto Update ms excel/access Forum Excel Auto FIll Issue Forum How can i get an excel auto dialer to work on xp Forum Number pad not working ion Windows 7 Excel Forum Automatic number sequence in excel Forum Solvedhow do I find my cell phone number ? Forum Auto virus scan when starting Windows Excel Forum Excel 2013 - Subtract from cell 2 negative value in cell 1, but only if cell 1 is negative. Forum How to create counting numbers in EXCEL 2013 Forum Number a list under Excel Forum Protecting only certain cells in Excell Spreadsheet Forum i have been getting calls from a private number and my cell phone doesn't have an app to trap the caller caller Forum Excel standard format for cell Forum How Can I Connect Multiple Cell Phones To One Number? Forum Excel - using a range (in one cell) in a formula Forum Are we new users supposed to call this number? I have auto.. Forum Changing duration of auto-dial number tones & pauses Forum [Solved] In Excel 2007, can I drag a cell to another column or row? Forum INSERT ROWS BASED ON CELL VALUE EXCEL Forum More resources Read discussions in other Windows 7 categories Configuration Customization Drivers Security Laptops !