Last Row in Column
Last Column in Row
Activates the last filled cell of the active column or the last filled cell of the active row.
Press the [SHIFT] key once before you select one of these tools from the menu, to select until the last filled cell instead.
See also:
Copy From Active to Last Selected Cell
Goto Last / Select until Last
Turn Selection