| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Serial No
Hi All,
If I write 1, 2, 3, in an excel sheet column & drag it to 30th column it becomes a complete serail from 1 to 30 but when I delete one row i have to do the same practice again, I also tried A1+1 & drag it but when I delete any row it gives #Ref error is there any way to automate the serial. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto calculate day of week to week of the year (not as serial) | Excel Discussion (Misc queries) | |||
| Serial No. | Excel Discussion (Misc queries) | |||
| attaching serial numbers | Excel Discussion (Misc queries) | |||
| Serial nos for unique records | Excel Worksheet Functions | |||
| Serial Dates | Excel Discussion (Misc queries) | |||
Threaded Mode
