You can use the Row function in Excel formulas to access the row number of any particular cell. For example, Row(B5) will give you the numeric result "5" and Row(A1) will give you the number "1".

How to Filter a List in Microsoft Excel With Limits on the Numbers of Rows. Excel spreadsheets can grow unwieldy as they get larger ... Excel adds filtering controls to column headers automatically.