Shortcut key to highlight the entire column
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
Ctrl + Space
Display Fill Color
Access Key: Alt + H + H
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.
Highlighted the column
Columns could now be highlighted in color.