Excel Hack

Excel shortcut highlight cell yellow

If you want to explore a particular cell in Excel, it is useful to highlight that cell yellow. To turn a cell yellow, most people would select the cell with the mouse and highlight it yellow. However, you can easily highlight a cell yellow by using a shortcut. Here are shortcuts for highlighting a single cell yellow and for highlighting multiple cells (including distant cells) yellow.

Shortcut to highlight cells yellow

Windows
Access key: Alt + H + H

Mac
None

Use shortcut to highlight a cell yellow

See below for instructions on how to highlight a cell yellow using shortcut.

Total Time: 1 minute

Select a cell

Select a cell

Select the cell you wish to highlight yellow.

Open Fill Color and select Yellow

Press shortcut and then select yellow

Press Alt + H + H. Use the (Down Arrow key) and (Right Arrow key) to select Yellow.

Yellow highlights completed

Yellow highlights complete

Press Enter. The selected cell is now highlighted yellow.

Highlight multiple contiguous cells in yellow

Select a cell

Select one of the multiple cells you wish to highlight yellow.

Select multiple cells

Press Shift + (Down Arrow key) to select multiple cells you wish to highlight yellow.

Select Yellow

Press Alt + H + H. Use the (Down Arrow key) and (Right Arrow key) to select Yellow.

Yellow highlights complete

Press Enter. Multiple contiguous cells are now highlighted yellow.

Highlight multiple cells that are far apart in yellow

Select a cell

Select one of the multiple cells you wish to highlight yellow.

Selecting distant cells

Press Shift + F8. Press (Down Arrow key) several times to select the distant cell you wish to highlight yellow.

Select one more cell away

Press Shift + F8 + F8. Press (Down Arrow key) several times to select the distant cell you wish to highlight yellow.

Select Yellow

Press Alt + H + H. Use the (Down Arrow key) and (Right Arrow key) to select Yellow.

Yellow highlights complete

Press Enter. Multiple cells that are far from each other are now highlighted in yellow.