I imported a large amount of data, then used a recorded macro to clean
up the spreadsheet by deleting rows. But ctrl-End still goes to some
cell far beyond the lower-right of the current data.

How can I change where ctrl-End goes to?

I would appreciate both VBA and Excel keyboard instructions. I intend
to incorporate this into my clean-up macro. But I would like to be
able to do this manually sometimes.