Excel Hack

Shortcut key to highlight the entire column

  • Release Update
  • Written in Excel for Microsoft 365 version 2201

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

Select the cell in the column you want to highlight.

Select a column

The entire column is highlighted

Press Ctrl + Space to select the entire column.

Select a color

Select a color

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

Highlighted the column

Highlighted the Column

Columns could now be highlighted in color.