How to Display Table Row Numbers in Excel
In Excel tables, having each row number displayed is convenient so you can see where you are and how many records exist.
However, if you use static numbers or formulas like =ROW(1:1) to achieve this, you will inevitably run into issues later when you sort the table or delete rows.
There is a more robust solution though that involves taking away the row number of the table headers from the row number of the record, e.g. =ROW()-ROW(CustomerTable[# Headers]).
