Tip Printed from ExcelTip.com

---

Selecting a Column(s) or Row(s) Using Keyboard Shortcuts


Using keyboard shortcuts

To select Column(s) or Row(s) Using Keyboard Shortcuts:

To select a column(s), select a cell or several cells in a sheet, and press Ctrl+Spacebar.

To select a row(s), select a cell or several cells in a sheet, and press Shift+Spacebar.
To continue selecting columns or rows, press Shift+Arrow keys.