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

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

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

Highlighted the row

Highlighted the row

Rows could now be highlighted in color.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments