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 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. 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. Can't find your answer ? Ask ! Publish Related resources: ForumExcel Auto FIll Issue ForumExcel Auto Fill Issue ForumExcel standard format for cell ForumAutomatic number sequence in excel ForumExcel - using a range (in one cell ) in a formula ForumAre we new users supposed to call this number ? I have auto .. ForumPDA for just Outlook Calendar and Excel spreadsheets for t.. ForumNumber a list under Excel ForumINSERT ROWS BASED ON CELL VALUE EXCEL ForumNot enough memory in excel ForumLooking for best hardware and system settingsfor Excel calculations... ForumExcel Formula IF, SUM, ETC...need help Forum"Reboot and select Proper boot device" ForumSony vaio model number PCG-71911f , where do i adjust volume , bought secondhand ForumSerial number need for speed the run ForumHow to format headers in excel ForumHow to auto boot my 64 bit system ForumHow to search idea mobile number detail ForumNumber pad not working properly. ForumHow 2 trace a laptop with its serial number More resources Read discussions in other Windows 7 categories Configuration Customization Drivers Security Laptops !