Excel Shortcut to Highlight Cells: Fill Color Guide

In Excel for Microsoft 365 on Windows, press Alt, then H, then H to open the Fill Color palette; choose a color to highlight the selected cells. Excel does not have one universal shortcut that instantly applies a particular highlight color, so the final step depends on the color you want and the palette shown.

What the Excel highlight shortcut does

In Excel, people usually mean adding a background color to one or more cells when they ask how to highlight something. The Windows key sequence Alt, H, H opens the Fill Color menu on the Home tab. The first Alt activates ribbon Key Tips, the first H selects Home, and the second H opens Fill Color. Press the keys in sequence rather than holding all three down together.

This is a menu shortcut, not a direct yellow-fill command. Choose a swatch from the palette, which can include theme colors, standard colors, and an option for more colors. Excel may display the current fill color on the main Fill Color button; clicking that button applies the current color, while its arrow opens the palette. The keyboard sequence is useful when you want to stay at the keyboard and pick a fill color.

The palette may look different if the workbook uses a different theme, and the available Key Tips can vary with Excel’s interface language. If the sequence does not open the menu, check that Excel—not another app or dialog—is active, and use the Key Tips displayed on your own ribbon.

How to highlight cells with a fill color

To apply a color with the keyboard, first select the target cell or range, then open the Fill Color palette and choose the swatch. For example, to shade a heading row pale yellow, select the cells that contain the headings, press Alt, H, H, and choose a pale-yellow swatch. The fill applies to every selected cell, not just the active cell within the selection.

Click a cell or select the range you want to format.
Press Alt, then H, then H.
Use the arrow keys to move through available color choices if needed, then press Enter to apply the selected swatch. The palette’s focus behavior can vary, so follow the visible selection and Key Tips.

You can also use the mouse: go to Home > Fill Color and click the button to apply its displayed color, or click the arrow beside it to select another one. To choose a precise custom shade, open the palette and use More Colors when it is available. A color that looks subtle on screen may print differently, so check a print preview if the workbook is meant for paper.

Select the right cells before formatting

The formatting shortcut changes the cells that are selected, so selection is an important part of the job. Click a single cell to color only that cell. To select a continuous range, click its first cell, hold Shift, and click the last cell, or use the arrow keys while holding Shift. You can also type a range such as B2:E2 in the Name Box, then press Enter to select it before applying a fill.

Several Windows shortcuts make common selections quicker:

Ctrl+Space selects the entire column of the active cell.
Shift+Space selects the entire row of the active cell.
Ctrl+Shift+Arrow key extends the selection toward the edge of a data region in that direction. Blank cells and surrounding data can affect where the selection stops.
Ctrl+A selects the current data region in many worksheet contexts; pressing it again can select more of the sheet, depending on where the active cell is.

For nonadjacent cells, hold Ctrl while clicking each additional cell or range, then apply the fill. Be careful when selecting an entire row or column: a fill can affect cells beyond the visible table and may add formatting to areas where it is not useful.

Highlighting cells is not the same as highlighting text

Excel’s Fill Color command colors the background of a cell. It does not work like the marker-style text highlight tool in Word, and Excel has no built-in command that puts a colored background behind only a few selected characters inside a cell. If you select text within a cell and use Fill Color, the cell’s background is still what changes.

If you need to draw attention to part of a label, alternatives include changing the font color or making the characters bold. You can edit the cell, select the relevant characters in the formula bar or within the cell, and use font formatting where supported. Character-level formatting is more limited and less convenient than cell formatting, particularly when values are generated by formulas. For most tables, coloring the whole cell or using a clear font style is easier to maintain.

Also distinguish a manual fill from conditional formatting. A manual fill stays until someone changes or clears it. Conditional formatting applies a visual rule based on a value or condition, so the highlighted cells can update as the worksheet data changes.

Use conditional formatting for changing highlights

If the goal is to highlight cells that meet a condition—such as overdue dates, repeated values, or numbers above a threshold—use Home > Conditional Formatting rather than coloring each cell manually. Excel includes choices under Highlight Cells Rules, such as rules for values greater than or less than a number, text that contains specified content, dates in a chosen period, and duplicate values.

For example, to call attention to amounts above a limit, select the amount range, open Home > Conditional Formatting > Highlight Cells Rules > Greater Than, enter the threshold, and choose a format. The cells meeting the rule receive the chosen appearance; if their values later change so they no longer meet it, Excel updates the formatting. This is better than a manual fill when the result needs to remain accurate as new data is entered.

Conditional formatting can be more complex than a one-time fill. Multiple rules can apply to the same cells, and their order or settings can affect which appearance is shown. To inspect or adjust them, use Home > Conditional Formatting > Manage Rules. A static fill is usually simpler for a heading or a one-off note; a rule is usually preferable for data-driven alerts.

Reuse a highlight color and remove it

When the desired color is already displayed on the Fill Color button, clicking the main button is the quickest way to apply it again with the mouse. If using the keyboard, Alt, H, H opens the palette so you can choose the color. Excel does not provide a universal built-in shortcut that always applies yellow regardless of the current workbook or selected color.

To remove a cell background, select the cells, open the Fill Color menu, and choose No Fill. This removes the fill while preserving other cell formatting, such as bold text, borders, and number formats. By contrast, Home > Clear > Clear Formats removes a broader range of formatting, so it may also erase styles you intended to keep. Use No Fill when the problem is only the background color.

For repeated formatting across different areas, the Format Painter on the Home tab can copy formatting from one cell or range to another. Select the source, choose Format Painter, then select the destination. It copies formatting rather than the underlying value, but may also copy borders, number formats, and font styles along with the fill. Check the destination before using it across a large range.

Windows, Mac, and Excel for the web

The instructions above are for Excel for Microsoft 365 on Windows. On a Mac, the Windows Alt Key Tip sequence Alt, H, H is not the equivalent way to navigate the ribbon. Select the cells and use the Fill Color control on the Home tab. Mac keyboard shortcuts can differ by Excel version, macOS settings, and keyboard layout, so use the ribbon’s tooltips or Excel’s shortcut help rather than assuming a Windows sequence will work.

Excel for the web also has a Home tab and Fill Color control, but browser and web-app keyboard handling can affect Alt-based ribbon navigation. If the key sequence is intercepted or does not show Key Tips, use the ribbon control instead. In all versions, the underlying idea is the same: select cells first, then apply a fill color. The visual controls are the reliable fallback when a desktop shortcut is unavailable or behaves differently.

Common shortcut problems

The whole sheet or the wrong cells changed: Check the selection before applying the color. The fill affects the current selection, which may include a full row, column, or larger range than expected.
The shortcut opened a different command: Press the keys in sequence and look for the ribbon Key Tips. The letters can vary with interface language, and a dialog or another active window can change keyboard behavior.
The selected color is not yellow: The shortcut opens the palette; it does not promise a specific shade. Choose the intended swatch, or set the color you need using the Fill Color menu.
The fill seems not to appear: Confirm that the cells are selected and that the chosen color contrasts with the worksheet background. A very light shade can be hard to see, and other formatting or conditional-formatting rules may affect the appearance.
You removed more formatting than intended: Use No Fill to clear only the background. Clear Formats can remove other formatting as well.

One common misconception is that Excel has the same dedicated text highlighter as Word. It does not: the standard Fill Color command colors cells, while conditional formatting supplies rule-based cell appearances. Choosing between those options prevents accidental formatting and makes the result easier to maintain.

Frequently Asked Questions

What is the keyboard shortcut to highlight a cell in Excel?
On Windows, press Alt, then H, then H to open the Fill Color palette. Select a color to apply it to the active cell or selected range.

How do I highlight a cell yellow with the keyboard?
Select the cell, press Alt, H, H, and choose a yellow swatch from the palette. The shortcut opens the color choices; it does not always apply yellow automatically.

Can I highlight only part of the text in an Excel cell?
Excel does not provide Word’s marker-style text highlight for selected characters. You can use character-level font formatting for emphasis, or color the entire cell with Fill Color.

How do I remove highlighting without clearing other formatting?
Select the cells, open the Fill Color menu, and choose No Fill. Avoid Clear Formats if you want to keep borders, fonts, and number formats.

Can Excel highlight cells automatically when values change?
Yes. Create a rule through Home > Conditional Formatting, such as a Highlight Cells Rule for values above a threshold. The formatting updates when the cell values change and the rule’s conditions change.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.