Shortcut to highlight row in Excel
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.
Highlighted the row

Rows could now be highlighted in color.