To highlight cells in Excel with a keyboard on Windows, select the cell or range, press Alt, H, H, use the arrow keys to choose a fill color, and press Enter. The color fills the selected cells; it is different from the temporary outline that shows which cell is active. You do not need to change Excel settings first, but you do need an open workbook and a selection to format.
What You’ll Need
- Microsoft Excel for Microsoft 365 on a Windows computer. The steps below use its standard ribbon key tips.
- A workbook you can edit. If it is read-only or protected, you may not be able to apply formatting.
- The cell, range, row, or column you want to highlight. You can select it with the keyboard before choosing a color.
On Mac, the selection techniques are similar, but the Windows Alt key-tip sequence for Fill Color does not apply. Mac notes are included below.
Step-by-Step
- Open the worksheet and decide what to mark. Identify whether you want to color one cell, a rectangular block, a whole row or column, or cells that meet a condition. The usual Fill Color command applies a chosen color to whatever is selected. It does not automatically identify values or update the highlight when data changes.
- Move to the first cell with the arrow keys. Click a cell if you are not requiring a fully keyboard-driven workflow, or use the arrow keys to move the active cell. The active cell is the one with the bold outline. If a cell is being edited, press Esc to leave edit mode before trying to move or extend the selection.
- Select the cells you want to highlight. For a nearby range, hold Shift and press an arrow key to extend the selection one cell at a time. For a contiguous block, start at a corner and use Ctrl+Shift with an arrow key to extend to the edge of the filled data region. This can select farther than intended if there are no blank cells to stop the selection, so check the highlighted selection outline before applying a color.
- Select a precise range by address when that is easier. Press Ctrl+G to open Go To, type a range such as
B2:D8, then press Enter. Excel selects that range, including its first and last cells. You can enter a single address, such asF4, the same way. This is useful for large ranges because it avoids holding an arrow-key shortcut for a long time. - Select an entire row or column if needed. Move to a cell in the target row and press Shift+Space to select the row. Press Ctrl+Space to select the column containing the active cell. A full-row or full-column fill affects cells beyond the visible data, so use a bounded range instead if you only want to color part of the sheet.
- Open the Fill Color palette. Press and release Alt, then press H, then press H again. These are sequential key presses, not a combination that you hold down together. The first key opens Excel’s ribbon key tips, and the following keys open the Fill Color palette on the Home tab. If the letters shown on your screen differ, follow the key tips Excel displays; ribbon key tips can vary with interface language or layout.
- Choose a color from the palette. Use the arrow keys to move through the available colors. The palette includes theme colors and standard colors; the name or preview of the focused color may be shown as you navigate. Press Enter to apply the focused color to the selection. If the palette is open but you decide not to format anything, press Esc to close it without making a choice.
- Check the result and save your work. Look at the cells to confirm that the fill appears on the intended range and that the text is still readable. Press Ctrl+S to save. If you applied the fill to the wrong cells, press Ctrl+Z once to undo the formatting, then select the correct range and try again.
Mac note: Excel for Mac does not use the Windows Alt, H, H key-tip sequence. You can select a range with Shift+arrow keys; Control+Shift+arrow keys can extend a selection through a data region. Shift+Space selects a row. Control+Space generally selects a column, but macOS may reserve that shortcut for switching input sources. To apply a color, open the Home tab and choose the Fill Color button. For keyboard-only access to ribbon controls, enable keyboard navigation in macOS settings and use the focus-navigation keys and arrows; exact behavior depends on your macOS and Excel settings. There is no Windows-style Fill Color key-tip sequence to rely on for Mac.
Common Mistakes
- Confusing selection with highlighting. The border around the active cell or selected range is only a selection indicator. It may disappear when you move elsewhere or print the worksheet. Fill Color applies a lasting cell background instead.
- Pressing the key tips simultaneously. Alt, H, H is a sequence. Press Alt and release it, then type the letters in order. Holding all three keys together will not open the palette as intended.
- Using the wrong color command. The Home tab has separate controls for Font Color and Fill Color. The Fill Color button is the paint-bucket control; Font Color changes the text itself. If you change the lettering instead of the background, undo and choose Fill Color.
- Selecting more cells than intended. Ctrl+Shift+an arrow can extend to the edge of a continuous data block, or to the worksheet edge if there is no stopping blank. Use Ctrl+G and a specific range address when accuracy matters.
- Using a very dark fill behind dark text. A fill can make labels and numbers hard to read. Choose a light shade for dark text, or adjust the font color as a separate formatting step. Consider how the colors will look when printed or viewed by someone with limited color perception.
- Expecting a manual fill to react to data changes. A chosen fill stays where you applied it; it will not automatically move to a different cell when values change. Use Conditional Formatting when the color should depend on a rule.
Tips
- Use Go To for disconnected cells. In the Go To box, you can type multiple references separated by commas, such as
A2,A5,C3, and press Enter to select those nonadjacent cells. Then apply one fill to all of them. Check the selection before formatting, especially if the addresses are spread across the sheet. - Pick a color that communicates something consistently. For example, reserve pale yellow for items that need review and pale green for completed items. A small, consistent color scheme is easier to understand than many unrelated colors. If color alone carries important meaning, also add a word, symbol, or other cue.
- Use a table header as a clear target. If you only want to emphasize labels, select the header cells rather than the entire worksheet columns. This keeps the visual emphasis focused and avoids coloring empty rows below the data.
- Use Conditional Formatting for changing results. If cells should highlight when they contain a value, date, duplicate, or text, go to Home > Conditional Formatting and choose an appropriate rule. A conditional format can update when the cell values change; a manually selected Fill Color does not. The keyboard path for building a rule depends on which rule type you choose.
- Keep the selection visible while working. After opening the color palette, do not click or navigate elsewhere before choosing a shade. The fill applies to the current selection, so changing the selection first can lead to an unexpected result.
- Remember the last-used fill, but verify it. The main Fill Color button may apply the color currently shown on its split-button rather than opening the palette. The key-tip sequence above opens the palette so you can choose deliberately. If you use the main button afterward, confirm its displayed color first.
Troubleshooting
Nothing happens after pressing Alt, H, H. Make sure Excel has focus and the worksheet is not in cell-edit mode. Press Esc once, then try again, pressing each key in sequence. If key tips appear after Alt, use the letters shown on your ribbon; a different Office language or customized ribbon can use different labels. On a laptop, check whether the function or Alt key is being intercepted by a keyboard utility.
The cells turn a color you did not choose. Undo with Ctrl+Z, reopen the palette, and navigate until the intended shade is focused before pressing Enter. Be careful not to press Enter while the current color is still selected. Also check that you opened Fill Color and not a nearby formatting command.
The color appears to have no effect. The cells may already have that fill, or their displayed color may be controlled by a conditional formatting rule or a table style. Try a noticeably different color as a test. For conditional formatting, inspect Home > Conditional Formatting > Manage Rules. A rule can override or visually mask the manual fill, so adjust or remove the rule only if it is appropriate for the worksheet.
You cannot change the formatting. The sheet may be protected, the workbook may be read-only, or you may lack permission to edit it. Check the title bar and the Review tab for protection controls. If protection is intentional, ask the workbook owner for access rather than trying to bypass it.
The shortcut behaves differently on Mac. Do not use the Windows Alt key-tip sequence in Excel for Mac. Select the cells with Mac-supported navigation, then use the Home tab’s Fill Color control. If keyboard focus will not move through ribbon controls, check macOS keyboard navigation settings; a system shortcut can also take precedence over a shortcut in Excel.
Frequently Asked Questions
What is the keyboard shortcut to highlight cells in Excel?
In Excel for Microsoft 365 on Windows, select the cells, then press Alt, H, H in sequence. Use the arrow keys to choose a fill and press Enter. The sequence opens the palette; it does not choose a particular color by itself.
Can I highlight cells without using a mouse?
Yes, on Windows you can select a cell or range with the keyboard, open the Fill Color palette with the key tips, navigate colors with the arrow keys, and confirm with Enter. On Mac, select cells by keyboard and use keyboard navigation to reach the Home tab’s Fill Color control; the exact focus method depends on macOS settings.
How do I highlight an entire row or column with the keyboard?
On Windows, select a cell in the row and press Shift+Space; for its column, press Ctrl+Space. Then choose a fill color. To color only part of a row or column, select a bounded range instead.
How do I remove a highlight using the keyboard?
Select the filled cells, open the Fill Color palette, and choose No Fill if it is available in the palette. On Windows, you can use the same Alt, H, H sequence to open it. If you just applied the fill and have not made another change, Ctrl+Z also undoes it.
Will the highlight appear when I print the worksheet?
A cell fill normally appears in print, unlike the temporary selection outline. Print settings, conditional formatting, and printer output can affect the result. Use Print Preview to check the page before printing, especially if the fill is very light.
How can I highlight cells automatically when their values change?
Use Home > Conditional Formatting to create a rule based on a cell value, text, or another supported condition. Unlike a manual fill, the rule can change the displayed highlight as the data changes. Choose the rule type carefully and check its range in Manage Rules.
Related
- How to Find the Indent Level in Excel Cells and Check It
- How to Find Hidden Sheets in Excel
- How to Find the Highest Average in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Link Two Data Validation Lists in Excel: Step-by-StepTo link two data validation lists in Excel, make the first dropdown a category list, create a named…
- How to Close Excel Using the Keyboard on Windows PCTo close Excel on a Windows PC, press Alt+F4 while the Excel window is active. If the workbook…
- Add a Header to a Word Document in Microsoft 365To add a header in Word for Microsoft 365 on Windows, open the document and choose Insert >…
- Excel Get Data From Table or Range: A Practical GuideTo get data from a worksheet table or cell range into Power Query in Excel for Microsoft 365…
- Outlook Share Calendar With Limited Details?Yes. Outlook can let someone see that you are busy without showing what your appointments are about, or…
- Open Excel for the Web in the Desktop App: How to SwitchTo open an Excel for the web workbook in the desktop app, open the workbook in your browser,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.