7 Keyboard Shortcuts For Quick Cell Selection

7 great keyboard shortcuts for selecting cells quickly.

Shift + Arrow Keys – Expands the selected range in the direction of the arrow key.
Shift + Spacebar – Selects the entire row or rows of the selected range.
Ctrl + Spacebar – Selects the entire column or columns of the selected range.
F8 – Enters the extend selection mode. Press F8 again to exit the mode.
Shift + F8 – Enters the add selection mode. Press Shift + F8 again to exit the mode.
Ctrl + G – Opens the Go To window to select a range or range name.
Ctrl + A – Selects the entire worksheet.

About the Author

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.