How to select row and column by keyboard
Excel
2016
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 this tip in French: Comment sélectionner une ligne et une colonne au clavier.