Shortcut key to highlight the entire column

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

This section describes a shortcut for highlighting an entire column by changing its color. Although it is possible to highlight an entire column with the mouse, it is easier and faster to use a shortcut. When you change the color of an entire column, only that column stands out, making it easier to catch the viewer’s eye. Take this opportunity to learn the shortcuts and increase your work productivity.

Highlight columns shortcut

Select column

Windows
Ctrl + Space

Mac
None

Display Fill Color

Windows
Access Key: Alt + H + H

Mac
None

Highlight a column with a color

Explains how to highlight a column with a color.

Total Time: 1 minute

Select a cell

Select the cell in the column you want to highlight.

Select a column

Press Ctrl + Space to select the entire column.

Select a color

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