Add autonumbering to your Excel spreadsheet

Unlike Access, Excel does not have an autonumbering feature that increments a number each time you add a new row. With Excel 2003 and 2007, you can use the Row function to add your own autonumbering to a data list.

For example, say you are creating a list of all of your company's products and their prices. Follow these steps to add your own autonumbering for the list: