EXCEL AUTO Row Numbering …


To automatically include Row Number quickly in your excel worksheets, you can use this formula in each cell. =ROW() – ROW($A$8) + 1 where cell A8 is the #1 row.

You must be sure to make the cell reference absolute using the $.  Iif you add or delete rows above the first row, this absolute reference is adjusted correctly to keep the reference to the first cell so the first row is always numbered 1. It saves having to enter beginning row number into a different cell elsewhere on the worksheet.


Light bulb Another Tip From: http://www.OfficeUsers.org


    Microsoft Store

    This site uses Akismet to reduce spam. Learn how your comment data is processed.