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?
برچسب:
نویسنده: استخدام کار