Articles & News
Graphics & Displays
Tom's IT Pro
Login | Sign Up
The authority on tech
Apps General Discussion
Automatic number sequence in excel
Oct 19, 2011, 5:34 AM
how to generate Automatic number sequence in excel?
if i have 5 rows with column name "Serial No" like this
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
Aug 23, 2015
automatic number sequence excel
Oct 19, 2011, 9:08 AM
I think excel does it automatically. Doesn't it?
You just drag the columns and tell excel to fill the series!
Oct 19, 2011, 10:52 AM
i have tried but after adding rows there is no auto generate numbering.
Locking an Excel sheet
How to lock a excel farmula
[Q] Advanced Excel Mail-Merge
I replaced an excel file with the other one how do i recover it
Can't find your answer ? Ask !
Get the answer
Oct 19, 2011, 11:32 AM
You just have to drag the column once again with the empty blocks as well. That should fill it up.
Oct 19, 2011, 12:20 PM
Take a look at this too
Ask a new question
How to create an empty cells in excel file
Excel - How to prevent the right click on the Worksheet Tab
How to select item using combo-box in ms-excel?
Alt + tab between open excel workbooks doesn't work anymore
I need a calendar in excel with holiday list of differnt countries
In Excel 2007, can I drag a cell to another column or row?
Auto number in excel cells
How to lock a ms excel sheet
How to lock excel sheet
How to Lock Excel work book
Free down load on excel 2007
Subscribe to our newsletter
icon arrow stem circle
About Tom's Hardware
Licensing and Reprints
Other Shopsavvy sites
© 2018 Purch All Rights Reserved.