Looking for a keyboard shortcut which moves the cursor to the last populated cell in the current row, even when there may be blank cells in the row.

IOW the equivalent of HOME (which moves to the 1st cell in the row, regardless of whether all cells are populated).

CTRL-right arrow is often described as "moving to the last populated cell in the row", but it does not. It moves to the last *contiguous* populated cell in a row, not the ultimate last cell. If any cells are blank it won't move to the last cell in a row.

It seems you frequently need to navigate to the 1st and last cells in a row. The HOME key works for the 1st cell, but I can't find a key for "move to last cell in a row".