Using Excel 97.
I have a worksheet with the last cell at F:1590
I know this as CTRL+END puts me at this cell.
I have nothing in this cell and want to make the "last cell" F:100
ie I want CTRL+END to put me at F:100.
I've tried deleting rows/cells etc but still CTRL+END puts me at F:1590