Excel Hack

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

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 a cell

Select the cell in the row you want to highlight.

Select a row

Select a row

Press Shift + Space to select the entire row.

Select a color

Select color

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

Highlighted the row

Highlight a row

Rows could now be highlighted in color.