Highlight in Excel Without a Mouse: Keyboard Steps

How-to basics · Updated November 20, 2026

To highlight cells in Excel without a mouse, select them with the keyboard, then press Alt, H, H on Windows to open the Fill Color palette. Choose a color with the arrow keys and press Enter. This applies a lasting background color; simply selecting cells only marks them temporarily while you work.

The steps below are for Excel for Microsoft 365 on Windows. You can select one cell, a range, a whole row or column, or separate areas, then apply a fill color without touching the mouse. Save your workbook first if you are making changes to an important file.

What You’ll Need

  • Excel for Microsoft 365 on Windows, with a workbook open.
  • A keyboard with an Alt key. You do not need a mouse or a special add-in.
  • The cell or range you want to color. If you already know its address, such as B2:D8, you can go directly to it with Go To.

Step-by-Step

  1. Move to the worksheet and starting cell. If you are in a cell, use the arrow keys to move the active-cell outline. Press Ctrl+Home to go to the beginning of the worksheet, usually A1. Use Ctrl+Page Down or Ctrl+Page Up to move between worksheet tabs. The active cell is the starting point for most keyboard selections.
  2. Select a single cell or a small range. To highlight just the active cell, leave it selected. To extend the selection, hold Shift and press an arrow key. For example, move to B2, then press Shift+Right Arrow twice and Shift+Down Arrow twice to select B2:D4. The active cell remains one corner of the selected range, and the other cells are included in the outlined area.
  3. Select a larger block quickly. Move to a cell inside the data, then press Ctrl+Shift+Right Arrow or Ctrl+Shift+Down Arrow to extend the selection to the edge of the contiguous data region in that direction. Use the left or up arrow to extend in the opposite direction. A blank cell can stop this shortcut, so inspect the selected boundary before applying color. To extend from the current cell to the last used cell on the sheet, press Ctrl+Shift+End; this may select more cells than you intend if the sheet has formatting or content far below your data.
  4. Go directly to a known range if that is easier. Press Ctrl+G to open Go To, type a cell or range reference such as B2:D8 in the Reference box, and press Enter. Excel selects that range. You can also use a named range if the workbook has one. This is often the quickest way to select a range when it is far from the current cell or when navigating through a large sheet.
  5. Select a whole row or column when needed. Move to any cell in the row and press Shift+Space to select the entire row. Press Ctrl+Space to select the entire column. These shortcuts include cells beyond the visible data, so use them only when you really want to color the full worksheet row or column. To select several adjacent rows, select the first row, then hold Shift and use the up or down arrow; for columns, use the corresponding left or right arrow while the column selection is active.
  6. Select separate areas if they do not touch. Press Ctrl+G, type the first range, then enter a comma and the next range in the Reference box, for example A2:A5,C2:C5, and press Enter. Excel can select multiple areas this way. Check that the ranges are separated by commas and that you have not included an unintended cell. If your workbook or regional settings do not accept the list as entered, select and color each range separately using Go To.
  7. Open the Fill Color palette from the keyboard. With the intended cells selected, press Alt, release it, then press H, followed by H. These are Excel ribbon Key Tips for Home > Fill Color. Press the letters in sequence rather than holding all three keys down at once. The Fill Color palette should open below the ribbon button. If a different ribbon command opens, press Esc and try the sequence again from the worksheet.
  8. Choose and apply the highlight color. Use the arrow keys to move through the palette. The highlighted swatch is the current choice; press Enter to apply it to the selected cells. If the palette displays theme colors, standard colors, or more color options, arrow through the available choices and watch the screen to see which swatch is focused. Press Esc to close the palette without choosing a new color. The fill you apply remains in the workbook after you move to another cell.
  9. Check the result and continue working. Press an arrow key to move away from the colored range and confirm the fill is still visible. If you need to color another range, select it and repeat the fill-color steps. To remove a fill later, select the cells, press Alt, then H, then H, and choose No Fill from the palette using the arrow keys and Enter. Do not confuse this with pressing Esc, which only closes the palette.

Mac and Excel for the web: The Windows sequence Alt, H, H is not a dependable shortcut on Mac. In Excel for Mac, select the cells with the keyboard, then navigate to Home > Fill Color using the ribbon’s keyboard navigation; the exact navigation keys can depend on your macOS keyboard-access settings and Excel version. On a Mac, Shift+arrow extends a selection; use the keyboard shortcut help in Excel for the current Mac-specific range-selection shortcuts. Excel for the web also has different Key Tips, so use its displayed ribbon hints rather than assuming the Windows sequence works.

Common Mistakes

  • Assuming a selection is a permanent highlight. The outline and temporary selection shading disappear when you move elsewhere. Apply a Fill Color to keep a visible background color in the worksheet.
  • Using the wrong kind of color command. Home > Font Color changes the text color, while Home > Fill Color changes the cell background. If the letters changed color but the cell did not, reopen Fill Color and choose a background swatch.
  • Pressing the Key Tips together. The ribbon sequence uses separate presses: Alt, then H, then H. Holding Alt while typing H twice may work on some keyboards, but pressing them in sequence is clearer and more reliable.
  • Selecting to the edge of a region without checking for blanks. Ctrl+Shift+Arrow stops at a blank or at the edge of the data region. If the table contains gaps, the selection may not cover the full intended range. Use Go To with a known address when precision matters.
  • Coloring a whole row or column by accident. Shift+Space and Ctrl+Space select entire worksheet rows and columns, not just the cells containing data. Verify the selection before choosing a fill.
  • Expecting a manual fill to update automatically. A fill color is ordinary formatting. It does not react to changed values or rules. For highlights that should appear when a condition is met, use Home > Conditional Formatting instead.

Tips

  • Use Go To for accuracy. When you know the exact address, Ctrl+G and a range reference are less error-prone than extending a selection across a distant worksheet.
  • Keep a simple color system. For example, use pale yellow for items to review and pale green for completed items. Choose colors that leave text easy to read, especially when the workbook may be printed or shared.
  • Try a test cell first. If you are unsure which palette swatch has keyboard focus, select an unused cell and apply the color there. Undo with Ctrl+Z if the test changes something you did not intend, then repeat on the target range.
  • Use Conditional Formatting for changing criteria. If you want all overdue dates or values above a threshold to stand out automatically, create a conditional formatting rule instead of manually coloring each cell. A manual fill will not recalculate when the underlying data changes.
  • Remember that the default button color can be applied directly. Clicking the main part of the Fill Color button applies its current color, while the arrow opens the palette. With the keyboard, Alt, H, H opens the palette so you can choose a color; check the displayed swatch before committing if you use the default repeatedly.

Troubleshooting

Alt, H, H does nothing: Click no controls; instead, press Esc until you return to the worksheet, then try the keys separately. Confirm you are using desktop Excel for Windows and that the workbook window is active. If the ribbon is hidden or a dialog is open, close the dialog or show the ribbon before retrying. Some keyboard layouts or remote desktop settings intercept Alt combinations.

The wrong cells become colored: Press Ctrl+Z immediately to undo the fill, then check the active-cell outline and selection boundary. Use Ctrl+G to select the precise address and repeat. If you selected an entire row or column by mistake, undo before proceeding.

The color is hard to see: Reopen the palette and pick a more distinct fill, or choose a lighter background so the text remains readable. If the cells already contain conditional formatting, its displayed color may take precedence over a manual fill. Review the rules under Home > Conditional Formatting > Manage Rules if the result does not match the fill you selected.

The palette closes but nothing changes: Make sure you selected a color rather than pressing Esc, and make sure the selection still covers the intended cells. If the worksheet is protected, formatting may be restricted. Check Review > Protect Sheet; you may need permission or the sheet password to change formatting.

Colors look different on screen or in print: Theme colors can vary with the workbook theme, and printed colors depend on printer settings. Check the workbook in Print Preview and use a clear contrast between the text and fill. A fill color may also be obscured by conditional formatting or by a cell style.

Frequently Asked Questions

How do I highlight cells in Excel without a mouse?
Select the cells with arrow keys, Shift+arrow, Ctrl+Shift+arrow, or Ctrl+G. Then press Alt, H, H, choose a fill color with the arrow keys, and press Enter.

Does selecting cells with the keyboard permanently highlight them?
No. The selection outline and temporary shading are only there to show which cells are active. Apply a Fill Color if you want a lasting background color.

Can I highlight multiple non-adjacent ranges?
Yes. Try Ctrl+G and enter multiple range references separated by commas, such as A2:A5,C2:C5. If Excel does not accept the list in your setup, apply the color to each range separately.

How do I highlight an entire row or column?
Move to a cell in the row and press Shift+Space, or move to a cell in the column and press Ctrl+Space. Then use the Fill Color palette. These shortcuts select the full worksheet row or column.

How can I remove a highlight without a mouse?
Select the colored cells, open the palette with Alt, H, H, move to No Fill, and press Enter. If you just applied the fill, Ctrl+Z is a quick way to undo it.

Will the Windows shortcut work in Excel for Mac?
Not reliably. Excel for Mac uses different keyboard and ribbon navigation. Select the cells with the keyboard, then navigate to Home > Fill Color using the Mac ribbon’s keyboard access; check Excel’s current shortcut help for your version.

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.