Excel Highlight Keyboard Shortcut: What Actually Works

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, select the cell or range and press Alt+H, H to open the Fill Color palette; choose a color to highlight the cells. There is no single universal key that instantly applies a new highlight color, because Excel’s shortcut opens the palette rather than choosing a particular color.

The quick answer: Alt+H, H

The sequence uses Excel’s ribbon Key Tips. Press and release Alt, then press H to open the Home tab’s keyboard commands, and press H again for Fill Color. These are successive key presses, not a three-key combination held down at once. Use the arrow keys to move through the available colors, then press Enter to apply the selected color.

The fill applies to the active cell or the selected range. If you want a specific color, navigate to it in the palette rather than assuming the shortcut will always apply yellow. Excel may show theme colors, standard colors, and recently used colors; the palette’s exact appearance depends on the workbook theme and Excel version. You can also use the mouse to choose a color after opening the palette with the shortcut.

For example, select B2:B8, press Alt, H, H, move to a pale yellow swatch, and press Enter. All seven selected cells receive that fill. The shortcut is useful when you want to keep your hands on the keyboard, but it does not identify or search for cells; you must select the target first.

How to select the cells before highlighting

Selection determines where the fill goes, so it is worth checking the selection before applying color. Click a single cell to highlight just that cell. To select a continuous block, click its first cell, hold Shift, and click the last cell, or drag across the range. You can also click the Name Box to the left of the formula bar, type a range such as B2:B8, and press Enter.

To highlight a whole row or column, click its row number or column letter before using the fill shortcut. To select several separate areas, hold Ctrl while selecting additional cells or ranges on Windows, then choose the fill. Take care when using a full-column selection: the formatting applies to every cell in that column, not only the rows currently containing data. A large formatted area can make a workbook harder to manage and may affect file performance in some situations.

When the active cell is part of a larger selection, the border around the selected area and the Name Box can help confirm what will be changed. If the result appears in the wrong place, undo immediately with Ctrl+Z and make the intended selection again.

What Excel means by highlight

In Excel, people commonly use “highlight” to mean changing a cell’s background color. Excel calls that formatting a fill. The Alt+H, H shortcut opens the Fill Color control on the Home tab, and the chosen fill colors the background of the selected cell or cells. It does not highlight only a word or a few characters inside a cell the way a text-marker tool might.

For emphasis on text, use font formatting instead. The Home tab’s Font Color control changes the color of the characters, while bolding or borders can make important values stand out without applying a background fill. For example, a pale fill behind a subtotal and bold text can distinguish it from ordinary rows, while a colored font can draw attention to a warning label.

Another common meaning is highlighting cells that meet a rule, such as all overdue dates or all values above a target. That is a different feature: Conditional Formatting. A manually applied fill stays on the cells until someone changes or removes it. Conditional formatting evaluates a rule and updates the appearance when the underlying values change.

Choose and change a fill color

After opening the Fill Color palette, choose a shade that maintains readable text. Light fills are generally easier to read with dark text, especially in a table with many rows. A very dark fill may require a contrasting font color, and intense colors across a large area can make the important information less obvious rather than more obvious. Consider accessibility too: color alone should not be the only way you communicate a status. Add a label, symbol, or other meaningful indicator where appropriate.

The palette’s default color is not a promise that every workbook will use the same shade. Theme colors can differ between workbooks, and the last-used color may be available as a convenient choice. To use a different shade, open the palette and choose from its displayed options, including the option for more colors if available. The color selection is stored as formatting, not as a value in the cell, so it does not change calculations or the text shown in the formula bar.

To remove a manually applied fill, select the cells, open Home > Fill Color, and choose No Fill. Do not confuse No Fill with a white fill: a white fill is still formatting and can cover a background color or pattern. If you choose Home > Clear > Clear Formats, Excel removes other formatting too, which may include number formats, borders, font styles, and fills. Use that broader command only when you intend to reset those features as well.

Apply the same color again

If you need to color several areas with the same fill, you usually do not need to revisit the palette each time. Select the next target and use the Fill Color button’s main portion on the Home tab to apply the currently displayed color. In many Excel ribbon layouts, clicking the main button applies its current color, while clicking its dropdown arrow opens the palette. Check which part you are activating, because the arrow is the part that lets you choose another shade.

You can also use Format Painter to copy the fill and other formatting from one cell or range to another. Select a cell with the desired appearance, choose Home > Format Painter, and then select the destination. Format Painter copies more than just the background color: it can copy font, borders, number formatting, and other formatting too. If you only want the fill, using Fill Color directly is usually more controlled.

For repeated manual color coding, a practical approach is to settle on a small set of meanings, such as pale yellow for items needing review and pale green for completed items. Keep the key consistent and make sure the colors are distinguishable. If other people use the workbook, a short legend can prevent them from guessing what each color means.

When Conditional Formatting is a better choice

Use Conditional Formatting when the highlight should depend on a value or update as the data changes. For example, to flag numbers below zero, select the relevant cells and choose Home > Conditional Formatting > Highlight Cells Rules, then select Less Than and enter 0. Choose a formatting style and confirm. Excel then applies the rule to the selected cells; if a value later changes from negative to positive, the rule’s formatting changes accordingly.

Conditional formatting is also useful for duplicate values, dates, thresholds, and visual comparisons. It is not the same as the keyboard shortcut for a one-time fill: the shortcut changes formatting directly, whereas a conditional-formatting rule keeps checking whether its condition is true. If a cell appears colored even after you choose No Fill, a conditional-formatting rule may be supplying the color. Review Home > Conditional Formatting > Manage Rules to inspect rules that apply to the selected range or worksheet.

For a small, one-off annotation, manual fill is straightforward. For a large list whose status can change, conditional formatting is usually more maintainable because it reduces the need to recolor cells by hand. Be cautious about layering many rules: rules can overlap, and their order or settings may affect which formatting appears.

Windows, Mac, and Excel for the web

The Alt+H, H Key Tip sequence described here is for Excel for Microsoft 365 on Windows. Ribbon Key Tips are a Windows feature, and the same sequence should not be assumed to work in Mac Excel. On a Mac, select the cells and use Home > Fill Color on the ribbon, then pick the desired color. Ribbon layout and keyboard access can vary with the Mac version and settings, so the visible command is the dependable route when the Windows sequence is unavailable.

In Excel for the web, select the cells and use the Fill Color control on the Home tab. Keyboard handling can depend on the browser and its shortcuts, so use the ribbon if Alt+H, H does not open the expected control. If you work in a workbook that is shared between desktop and web versions, the cell fill itself is ordinary workbook formatting, but the quickest way to apply it can differ by platform.

Common shortcut problems

  • The color palette does not open: Press and release Alt first, then type the two letters in sequence. Do not hold all three keys down together. Confirm that Excel, rather than another application or a browser, has focus.
  • The wrong cells change: Undo with Ctrl+Z, then inspect the selection and try again. A whole-row or whole-column selection affects more cells than a small range.
  • The color is not the shade expected: The shortcut opens a palette; it does not mean “apply yellow.” Move to and select the intended swatch, or choose a color from the palette’s additional options.
  • The fill seems impossible to remove: Select the cells and choose Home > Fill Color > No Fill. If color remains, inspect Conditional Formatting rules because they can override the appearance.
  • The color disappears or changes after editing: Check whether a conditional-formatting rule controls that range. Manual fill and rule-based formatting behave differently, especially when values change.

Frequently Asked Questions

Is there a one-key Excel shortcut to highlight cells?

No. In Excel for Microsoft 365 on Windows, Alt+H, H opens the Fill Color palette. You then choose a color. Excel does not provide one universal key that instantly applies a particular highlight shade in every workbook.

How do I highlight cells yellow with the keyboard?

Select the cells, press Alt, H, H in sequence, navigate to the yellow shade in the palette, and press Enter. The exact position of a shade depends on the palette shown, so choose by the displayed color rather than relying on a fixed number of arrow presses.

How do I remove highlighting in Excel?

Select the affected cells and choose Home > Fill Color > No Fill. If the color remains, check for a conditional-formatting rule. Avoid Clear Formats unless you also want to remove other formatting such as number formats, borders, and font styles.

Does the shortcut work in Excel for Mac?

The Windows Alt+H, H Key Tip sequence is not the Mac equivalent. In Mac Excel, select the range and use Home > Fill Color to choose a fill. Keyboard options may vary, so use the ribbon control if a shortcut does not work in your setup.

Can I highlight only part of the text in an Excel cell?

The Fill Color shortcut colors the cell background, not selected characters within a cell. To emphasize text, select the cell and use font formatting, or edit the cell and format particular characters if that is appropriate for the content. Conditional formatting also changes cell appearance based on rules, not just selected words.

Related

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.