I have 2 xls, I have named them big and small.

They contain the same information but the size is very different

for example the big file is 2,128K
the small file is only 40K

When I open the big file, and hit the end <CTRL and END key, it goes to row
66529, the small file is row 36. Actual row with input information is only
36. the rest are blanks.

In the small xls, all I did was delete the unused lines from the big xls.
Is there any function in xls than can remove these unused rows? In what
scenario does xls goes into the last cell of the page? how can this be
avoided.