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
Shift + Space
shift + space
Display Fill Color
Access Key: Alt + H + H
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.