Automatic number sequence in excel Tags: Office How To Excel Apps Last response: October 19, 2011 12:20 PM in Applications Share yasir siddiqui October 19, 2011 5:34:22 AM how to generate Automatic number sequence in excel? if i have 5 rows with column name "Serial No" like this S Number 1 2 3 4 5 If i insert 1 row between Serial Number 3 and 4 then i want excel to generate auto number sequence and then i should have serial number 1 to 6 like this S Number 1 2 3 4 5 6 More about : automatic number sequence excel hell_storm2004 October 19, 2011 9:08:59 AM I think excel does it automatically. Doesn't it? You just drag the columns and tell excel to fill the series! yasir siddiqui October 19, 2011 10:52:19 AM i have tried but after adding rows there is no auto generate numbering. Related resources Random Load Sequence of Systray Icons - Forum Auto number in excel cells - Forum Starp up sequence - Forum Windows 7 boot sequence takes 4 minutes - Forum Windows xp boot sequence - Forum Can't find your answer ? Ask ! Get the answer hell_storm2004 October 19, 2011 11:32:41 AM You just have to drag the column once again with the empty blocks as well. That should fill it up. nikorr October 19, 2011 12:20:25 PM Take a look at this too http://www.mcgimpsey.com/excel/udfs/sequentialnums.html Can't find your answer ? Ask ! Publish Related resources: Forumhttp://www.tomshardware.com/forum/ [...] -chit-chat Forumhttp://www.tomshardware.com/forum/ [...] -chit-chat ForumExcel 2010 help ForumINSERT ROWS BASED ON CELL VALUE EXCEL ForumExcel Formula ForumPDA for just Outlook Calendar and Excel spreadsheets for t.. ForumBios won't detect my harddrive ForumNeed a S775 MB with larger number of PCI-e x1 and SATA ports ForumExcel Question Forum3.5e Excel Character Sheet ForumExcel thinks it's smarter than me ForumWhat is the difference between Extended and normal version of a software? ForumExcel sumif function ForumColors of few inputs in excel are missing Forum[Solved] AVG does not start automatic scan what can I do? More resources Read discussions in other Applications categories Graphics Internet Applications Multimedia Office Security CAD Distributed Computing Drivers Enterprise Software Firmware Programming Photoshop Skype Wordpress !