How to select row and column by keyboard

Excel 2016 2013 2010 2007 2003

Ctrl+Spacebar   Selects the entire column:

Selects the entire column in Excel 365

Shift+Spacebar   Selects the entire row:

Selects the entire row in Excel 365

Ctrl+Shift+Spacebar or Ctrl+A   Selects the entire worksheet (or cells with data).

See also Quick way to select all cells.

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