If you truly deleted all the rows below your used cells and Excel continues
to think you've used the entire sheet, then I'm not sure what else to offer
you.

The part where you've described copying just the desired range to a new
workbook and STILL Ctrl-End takes you to the last row, that just sounds
fishy. Do you have any problems with other workbooks?

Do you ever select the entire worksheet and apply formatting (a real no-no)?


"Jessica Donadio" wrote:

I know this question has been asked numerous times, but my excel sheet is
being horribly stubborn so that the last row remains to be 65000 something.
I've tried everything, I've read the article on microsoft's page, tried
deleting the content, plus delete the rows, plus cancel all from the edit
menu, plus referencing the range to delete first through F5, plus any of the
macros that I found on the contexture website and other places online, and
nothing. I've tried copying and pasting the range I want to a new workbook,
everything, and nothing has worked. Is there anything else I can do?? Thank
you.

Jessica