“CTRL” “END” keys will not go to end of worksheet

[ar]

When I click “CTRL” “END” I want to go to the last row of data of the worksheet not the last row of blank cells on the bottom of worksheet. I do a lot of data editing and delete data at the end of the worksheets so I guess the blank cells are not really empty cells. How do I make Excel recognize delete cells as empty cells so I can use “CTRL” “END” to go to the last row of data?

[Juan Pablo González]

To reset the last used cell in a worksheet you need to do one of the following:

* Save
* Use 'ActiveSheet.UsedRange' in the Inmediate window of VB
* Make sure that you don't just "clear" the contents of cells, rows and columns, but delete them.