How to select row and column by keyboard
Excel
365
Ctrl+Spacebar Selects the entire column:

Shift+Spacebar Selects the entire row:

Ctrl+Shift+Spacebar or Ctrl+A Selects the entire worksheet (or cells with data).
See also Quick way to select all cells.