Manually reseting the used cell range

[Woody13]

sorry if this is a double post. My excel workbook is too large and I think
the problem is that I copied formats to the end of the sheet. When I hit
"Ctrl + End" it goes to the end of the sheet even though I have deleted the
cells and the rows manually. Any help is appreciated?

 

[Dave Peterson]

Did you save the workbook?

Did you close it and reopen it (then check it)?

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused

 

[Ron de Bruin]

Hi Woody13

Look here
http://www.contextures.com/xlfaqApp.html#Unused