GoTo Last Cell

[macajm]

If I have deleted data or even deleted rows at the end of my spreadsheet, then when using the menu item "Edit|GoTo|Special|Lastcell the current cell becomes that maximum number of cells ever used, rather than the last non-blank cell.
Does anyone know how to jump to the last cell containing data?

 

[IRstuff]

you have to save or reopen the sheet. Otherwise, you have dangling formatting that resides past the actual data, and you'll need to find them and get rid of them

TTFN

 

[macajm]

Thanks IRstuff - what you say works - strange, but true!