Excel Highlight Shortcut: How to Color Cells Quickly

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, select the cell or range you want to highlight, then press Alt, H, H in sequence to open the Fill Color palette. Use the arrow keys to choose a color and press Enter. This applies a background fill to the selected cells; it does not highlight text with a marker as Word does.

What You’ll Need

  • A workbook open in Excel for Microsoft 365 on Windows. The steps also apply to many recent desktop versions of Excel, though ribbon labels can vary slightly.
  • A selected cell or range. You can select cells with the mouse, or use the keyboard methods described below.
  • A color choice in mind, especially if the fill will communicate meaning such as overdue, complete, or needs review. If other people use the workbook, choose a color that is easy to distinguish.

Step-by-Step

  1. Select the cell or cells. Click a single cell to color it. For a range, click and drag across the cells. To select a contiguous range by keyboard, select its first cell, hold Shift, and use the arrow keys to extend the selection. You can also click the Name Box to the left of the formula bar, type a range such as B2:E8, and press Enter. Check the selection outline before continuing; the fill will apply to every selected cell.
  2. Open the Fill Color palette. Press and release Alt, then press H, then press H again. These are sequential key presses, not a combination to hold down together. The first key opens Excel’s ribbon KeyTips, and the following keys point to the Home tab’s Fill Color control. The palette should appear below the paint-bucket icon.
  3. Choose a color. Use the arrow keys to move among the available theme colors and standard colors. Look at the color preview or the palette label as you move, then press Enter to apply the highlighted choice. If the palette is not open, do not press Enter blindly: press Esc, confirm the selection, and repeat the shortcut. You can also use the mouse to click a swatch in the palette.
  4. Confirm the result. The selected cells should now show the fill color. Click a different cell to see the result without the selection outline obscuring it. If the color is too strong, reopen the palette and choose a lighter shade. Text and numbers in the cells remain in place; this action changes the cell background, not the font color or the data.
  5. Apply the same color to another area. Select the next cell or range and repeat Alt, H, H. Excel generally remembers the most recently used fill color, but check the swatch before applying it if the exact color matters. If the shortcut opens the palette, choose the intended color again rather than assuming a particular color will be selected.
  6. Remove a fill if you chose the wrong one. Select the affected cells, open the Fill Color palette with Alt, H, H, and choose No Fill from the palette. This clears the background fill without deleting the cell contents. If you only just applied the color, Ctrl+Z can also undo that formatting change.
  7. Use the ribbon when the shortcut is inconvenient. Select the cells, then choose Home > Fill Color using the paint-bucket button’s dropdown arrow and click a swatch. On Excel for Mac, use this ribbon route: the Windows KeyTip sequence Alt, H, H is not a reliable Mac shortcut. Excel for the web also provides Home > Fill Color; browser and operating-system keyboard handling can affect ribbon shortcuts, so the visible control is the dependable alternative.

The shortcut is most useful when you already know what range needs a visual mark and want to avoid moving to the ribbon with the mouse. For example, to flag three cells in a status column, select those cells, open the palette, and choose a consistent light fill. The actual content is unchanged, so formulas continue to calculate and sorting or filtering still works as usual.

Common Mistakes

  • Holding the keys as one chord. Alt, H, H is a sequence: tap Alt, let go, tap H, then tap H. Trying to hold all three at once may do nothing or trigger another command.
  • Confusing fill color with font color. The Fill Color paint bucket colors the cell background. The Font Color button changes the characters. If you want colored letters, select the text or cells and use Home > Font Color, not Fill Color.
  • Expecting a text-marker effect. Excel does not include Word’s freehand text-highlighter tool for ordinary worksheet cells. A cell fill colors the whole cell. For only part of a cell’s text, select the text while editing the cell and use the font color or font formatting controls instead; this is a different operation.
  • Changing the wrong cells. A fill applies to the entire selection. If a whole row or column is selected, the whole row or column may be colored. Check the selection boundary before opening the palette, and use Ctrl+Z promptly if the result is broader than intended.
  • Assuming the shortcut applies a particular color. The shortcut opens the Fill Color palette. It does not mean “yellow highlight,” and the color you see as the current choice may depend on prior formatting actions. Choose the swatch you want rather than relying on an assumed default.
  • Using manual fill for a changing condition. A fill applied with this shortcut is static. If a cell should change color when its value changes, use a conditional formatting rule instead of manually recoloring it each time.

Tips

  • Make a repeatable color system. Use the same fill for the same meaning throughout a workbook, such as pale yellow for items to review and pale green for completed items. Add a small legend if the meaning is not obvious to other readers.
  • Use light fills behind dark text. Strong or dark backgrounds can make values hard to read, especially when a worksheet is printed. Check the contrast at normal zoom and avoid relying on color alone to convey an important status.
  • Color a range efficiently. Select the full range first, then use the shortcut once. This is quicker and produces more consistent formatting than opening the palette for each individual cell.
  • Navigate to a range without scrolling. Type the address into the Name Box, such as D5:D20, and press Enter. Then use the shortcut. This is practical for large sheets or when the target cells are far apart from the current view.
  • Use conditional formatting for rules. To highlight values based on their contents, select the range and go to Home > Conditional Formatting, then choose a suitable rule. For example, Highlight Cells Rules can flag values greater than a threshold. This makes the formatting respond when the underlying values change.
  • Check for existing formatting. If a cell already has a fill, the new fill replaces its background color. It does not layer on top of the old color. If the workbook uses established formatting, make sure your choice fits its existing visual scheme.

Troubleshooting

Nothing happens after pressing Alt, H, H. First, make sure you are in the Excel desktop app and that a worksheet cell is active. Press the keys one at a time, releasing each before the next. If KeyTips appear after Alt but the next letters do not work, press Esc and use Home > Fill Color instead. Some keyboard layouts or other software can intercept shortcuts.

The palette opens, but the wrong color is applied. The highlighted swatch may not be the one you intended. Open the palette again and use the arrow keys to move deliberately, checking the preview before pressing Enter. Alternatively, click the dropdown arrow beside the paint bucket and select the exact swatch with the mouse.

The color does not seem visible. Click outside the selected range to remove the selection outline, then inspect the cells. A very pale shade can be subtle on a white screen. Choose a clearer fill if needed. Also check whether conditional formatting is controlling the displayed appearance; a conditional formatting rule can affect how cells appear as their values change.

The fill appears only on some cells. Check whether the full intended range was selected before applying the color. If cells are in a filtered list, hidden rows may not be obvious, and a selection made by dragging may not include every intended cell. Undo if necessary, select the target range more carefully, and apply the fill again.

You cannot remove the color by choosing another shade. To return cells to having no background fill, choose No Fill from the Fill Color dropdown. If the color comes from a conditional formatting rule, clearing the manual fill will not remove that rule; open Home > Conditional Formatting > Manage Rules to review rules for the selection or worksheet.

You are using Excel on a Mac or in a browser. Use the ribbon’s Home > Fill Color control if the Windows shortcut does not work. Keyboard navigation and KeyTips can differ by platform, browser, and keyboard settings. The ribbon method is consistent because it does not depend on the Windows sequence.

Frequently Asked Questions

What is the shortcut to highlight cells in Excel?
In Excel for Microsoft 365 on Windows, press Alt, H, H in sequence to open the Fill Color palette. Choose a color with the arrow keys and press Enter.

Is Alt+H+H pressed all at once?
No. Tap and release Alt, then press H, then press H again. The sequence opens the palette; it is not a three-key chord and does not by itself select a specific color.

What is the Excel highlight shortcut on Mac?
There is no dependable Mac equivalent to the Windows Alt, H, H KeyTip sequence. Select the cells and use Home > Fill Color in the ribbon. The exact keyboard navigation available can depend on your Mac and Excel settings.

How do I highlight text rather than a whole cell?
Excel’s Fill Color control colors the cell background, not text like a marker in Word. To change character color, use Home > Font Color. To format only some characters inside a cell, edit the cell, select the characters, and apply font formatting.

How do I highlight cells automatically based on their values?
Select the cells and choose Home > Conditional Formatting, then create a rule that matches the condition you need. Conditional formatting updates the appearance when values change; the Alt, H, H fill is a manual, fixed formatting choice.

How do I clear a highlight without deleting data?
Select the cells, open Home > Fill Color, and choose No Fill. This removes the manual background color while leaving the cell contents intact. Use Ctrl+Z if you need to undo the most recent formatting action instead.

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.