Excel-how do I reset the cell to which I go with a Control End?

[Gail Devoid]

I work with large files, and frequently want to highlight just the data
section. I start at cell A1, hold down the shift key, the control key, and
hit the End key. Sometimes this works great; other times, I get lots of empty
cells. Is there a way to reset the bottom right cell as the end of file?

 

[Gary''s Student]

Select all the empty cells in column A below your data and clear them.