How to select entire row in Excel keyboard shortcut

• Release Jan 24, 2022Update Aug 24, 2022
• Written in Excel for Microsoft 365 version 2202

This section explains how to select an entire row using only the keyboard. When you select a row in Excel, you need to move the mouse pointer to the row number and click on it, but if you use the shortcut keys, you can select the entire row using only the keyboard. This reduces the amount of time spent reaching for the mouse, thus increasing work efficiency.

Shortcut for selecting an entire row

Windows
Shift + Space

Mac
shift + space

Select an entire row using only the keyboard

Explains how to select an entire line using only the keyboard.

Total Time: 1 minute

Select a cell

Select the cell from which you want to select a row.

The entire row is selected

Press Shift + Space. The entire row will be selected.