autonumbering

Autonumbering will advance your numbered rows and keep them current, even if you should delete or add a row. Unfortunately, MS Excel does not ship with an autonumbering feature (like that found in MS Access), that increments a number each time you ... add a new row. In Excel 2003 and 2007 however, you can use the Row function to add your own autonumbering to a list. Say you want to create a list of all of your school's classes and their corresponding learning materials. Follow the steps below to add autonumbering to the list: In A1, enter the formula below: =TEXT(Row(A1),"000-000") Enter the name ... (view more)