It allows you to keep track of the data you are looking at without having to scroll back and forth to see the column or row labels.
This is one of the reasons Excel keeps the commonsense 'Freeze' feature for you.
With new Excel capacity to hold a million rows and numerous columns with numbers, it is easy to lose the connection between the value and its meaning on line 26935.