Learn › Excel › Select a row

Excel select row shortcut: Shift + Space

Select the whole row of the active cell with one key combination.

← All Excel shortcuts

With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.

WindowsShift+Space
MacShift+Space

Keys on keyboards of other languages

The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.

English (US)Shift+Space
HrvatskiShift+Razmaknica
DeutschUmschalt+Leertaste
EspañolShift+Espacio
FrançaisShift+Espace
PortuguêsShift+Espaço
ItalianoShift+Spazio
TürkçeShift+Boşluk
Bahasa IndonesiaShift+Spasi
PolskiShift+Spacja

What it does

Shift + Space selects the whole row of the active cell, from column A to the end of the sheet. Once the row is selected, you can bold it, color it, hide it, insert a row above it or delete it in one step.

When to use it

Use it as the first step of any job on a row: formatting a header row, inserting a row above, hiding or deleting a row. Hold Shift and press the Down or Up arrow to select more rows.

How to do it

  1. Click any cell in the row you want.
  2. Press Shift + Space. The whole row is highlighted.
  3. Hold Shift and press the Down or Up arrow to add more rows.
Good to know: Select the row first, then do the job. For example, Ctrl + B bolds the whole row and Ctrl + Shift + + inserts a row above it. If you only want the cells that have data, click the first cell and press Ctrl + Shift + Right arrow instead.

A quick example

In the orders table, click the Product cell C4 and press Shift + Space: the whole row 4 is selected. Hold Shift and press the Down arrow twice, and rows 4 to 6 are selected, ready to format, hide or delete together.

Shift + Space, Ctrl + Space and Ctrl + A

Shift + Space selects a row, Ctrl + Space selects a column, and Ctrl + A selects the whole table or the whole sheet. To select several rows with the mouse, click the first row number and Shift + click the last one. With the keyboard, hold Shift and press the Up or Down arrow.

Not working? Check this

  • Nothing happens: click into the sheet first, not into the formula bar or a search box.
  • Only text inside a cell is selected: you are editing the cell, with the cursor blinking inside it. Press Enter or Escape first, then try again.
  • The wrong rows are selected: Shift and the arrow keys extend the selection from the row you started in. Click a cell in the first row you want and start over.
  • On a Mac the shortcut is the same, Shift + Space.

Quick answers

What is the shortcut to select a row in Excel?

Click any cell in the row and press Shift + Space. The shortcut is the same on a Mac.

How do I select more than one row?

Select the first row with Shift + Space, then hold Shift and press the Down or Up arrow. Each press adds one row.

What is the difference between Shift + Space and clicking the row number?

Both select the whole row. Shift + Space keeps your hands on the keyboard, and you can extend the selection at once with Shift and the arrow keys.

← All Excel shortcuts

Chrome extensions

Free web tools

Free games