Locate the last cell
Dwain Smith has noticed that after deleting rows or columns from an Excel worksheet, <Ctrl>-<End> no longer takes him to the last non-empty cell. Annoying, isn't it? Actually, <Ctrl>-<End> takes you to the last cell that contains data or has ever been formatted in any way. In some cases you will need to delete all of the columns to the right of your data and all of the rows below your data to remove formatting. Then save the file and reopen it. Excel will now know what it should have known all along. û John Walkenbach
Category: spreadsheet
Issue: May 1998