How to select row and column by keyboard

Excel 365 2016 2013 2010 2007

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.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.