How to name all data except for header row in Excel

Suppose I have some data like this:

Name    Number
alan    1
bobby   2
cory    3
david   4

Assume that "Name" is in cell A1. I'd like to be able to name this range but not include the header row. I know that I can refer to the data as $A$2:$B$5, but I'd like to not have to have any knowledge about how many rows are in the table, and I definitely don't want to have to highlight the cells with a mouse. Is there any way to do this? And if the best way is to use $A$2:$B$5, is there any way to find out how many rows I'm dealing with besides scrolling all the way to the end?

Recent Questions...