Jumping to the Last Possible Cell

Re. my comment dated 2022-09-04, I have discovered the expressions for LastNonBlankRow and LastNonBlankCol do not properly account for dynamic array formulas. Replace both instances of LookIn:=xlFormulas with LookIn:=xlValues to correct them.

There is an error in my most recent comment below. It should be:

With ActiveSheet
    LastUsedCell = .Cells(LastUsedRow, LastUsedCol).Address
    If LastNonBlankRow <> 0 And LastNonBlankCol <> 0 Then _
        LastNonBlankCell = _
            .Cells(LastNonBlankRow, LastNonBlankCol).Address
End With

With the VBA expressions in my most recent comment below, perhaps I should have included these obvious text results:

With ActiveSheet
    LastUsedCell = .Cells(LastUsedRow, LastUsedCol).Address
    If LastNonBlankRow <> 0 Then LastNonBlankCell = _
        .Cells(LastNonBlankRow, LastNonBlankCol).Address
End With

Ctrl+End always jumps to the LastUsedCell. Notice it is possible for all cells to be blank; in this case, LastUsedCell is "$A$1" and LastNonBlankCell is "" (default string).
From my previous comment you might notice the logic for blank columns is especially confusing. My results are for Win 10 Excel 365 (64-bit). The results for previous (or future) versions might vary.
As described, both LastUsedRow and LastUsedCol count formatted cells that are blank. But if you select and format an entire blank row (like $15:$15) or blank column (like $H:$H), this does not imply that all blank cells in that row or column are counted; they are not. The actual result is as if only the first cell in the blank row or column was formatted; i.e., the blank row or column is considered Used, but not all blank cells in that row or column.
As described, LastUsedRow includes blank hidden rows. It is worth noting such rows are not included after unhidden (unlike blank hidden columns).

Here are some useful VBA expressions:

With ActiveSheet
    With .UsedRange
        LastUsedRow = .Row - 1 + .Rows.Count
        LastUsedCol = .Column - 1 + .Columns.Count
    End With
    Set R = .Cells.Find(What:="*", After:=.Cells(1), _
        LookAt:=xlPart, LookIn:=xlFormulas, MatchCase:=False, _
        SearchOrder:=xlByRows, SearchDirection:=xlPrevious)
    If R Is Nothing Then LastNonBlankRow = 0 _
        Else LastNonBlankRow = R.Row
    Set R = .Cells.Find(What:="*", After:=.Cells(1), _
        LookAt:=xlPart, LookIn:=xlFormulas, MatchCase:=False, _
        SearchOrder:=xlByColumns, SearchDirection:=xlPrevious)
    If R Is Nothing Then LastNonBlankCol = 0 _
        Else LastNonBlankCol = R.Column
End With

A blank cell contains neither a formula nor a constant. (A cell containing a constant apostrophe or space character looks blank but is not.) All Last... expressions count cells (including hidden cells) that contain a formula or a constant.
Both LastUsed... expressions also count formatted cells that are blank. LastUsedRow includes blank resized rows, but LastUsedCol does not include blank resized columns. LastUsedRow includes blank hidden rows. LastUsedCol includes blank hidden columns only if they were resized or adjacent to a resized column or a non-blank or formatted cell before hidden; in this case, they continue to be counted after unhidden until the workbook is closed and reopened. But if they remain hidden when the workbook is closed, they will be counted when the workbook is reopened.
The LastNonBlank... expressions exclude blank cells.
For the final example in my previous comment below, here are the results:
LastUsedRow/Col = 9/4
LastNonBlankRow/Col = 1/4

I always found it useful to run the following macro when I found the last cell was in an obscure location due to formatting issues. I put it in my autoloading personal macro workbook and use it quite often. If it didn't fix the problem I knew there actually had to be something unseen in cells, like spaces, and had to do a more manual row/column deletion solution.

Sub LastCellSet()


Set LastCell = Cells(Range(Cells(1, 1), ActiveSheet.UsedRange).Rows.Count, Range(Cells(1, 1), ActiveSheet.UsedRange).Columns.Count)
End Sub

I'm using Win 10 Excel 365 (64-bit). If I start Excel with a 'New blank workbook', Ctrl+End takes me to cell $A$1 on Sheet1 and ActiveSheet.UsedRange.Address is $A$1 as expected. If I resize column E, $A$1 is still the last used cell. But if I resize row 9, the last used cell becomes $A$9. Microsoft's procedure referenced by the Tip doesn't resolve the issue, nor does saving the file and restarting Excel.
If I enter a value in cell $B$1, the last used cell becomes $B$9. If I enter a formula in cell $C$1, the last used cell becomes $C$9. If I reformat blank cell $D$1 (change the font), the last used cell becomes $D$9.
I conclude the last used row is influenced by resizing.

You don't need to restart Excel to have the program recognize the reset last-cell position, you just need to hit Save on the workbook.
Using VBA any command involving the UsedRange property will also do it eg ActiveSheet.UsedRange.

If deleting rows and columns doesn't fix the issue try resetting all the row height beyond the data range to the standard height.