Visit Debra Dalgleish's site for some techniques for resetting that
lastusedcell.
http://www.contextures.com/xlfaqApp.html#Unused

mcwhirter wrote:

I often use the keyboard shortcut control-shift-end in Excel to highlight all
my data, but if I have deleted rows or columns from the original data this
still goes to the original bottom right cell, so it includes blank cells I no
longer want. How do you re-set the last used cell to be at the end of the
data and exclude the blanks?

--

Dave Peterson