Shortcut to highlight row in Excel

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

Here are some shortcut keys and access keys for highlighting lines. Learn how to select an entire row with the shortcut keys and highlight it with the color of your choice using the access key. Learning these shortcuts can be useful when creating lists in Excel or when you want to highlight data that has a problem.

Highlight rows shortcut

Select row

Windows
Shift + Space

Mac
shift + space

Display Fill Color

Windows
Access Key: Alt + H + H

Mac
None

Highlight a row with a color

Explains how to highlight a row with a color.

Total Time: 2 minutes

Select a cell

Select the cell in the row you want to highlight.

Select a row

Press Shift + Space to select the entire row.

Select a color

Press Alt + H + H. Use the ↓ (Down Arrow key) to select a color, and press Enter.