To highlight a row in Excel for Microsoft 365 on Windows, select a cell in the row, press Shift+Space to select the entire worksheet row, then press Alt, H, H in sequence to open the Fill Color palette. Choose a color and press Enter. You can also use the ribbon to apply a fill, and the Mac steps are slightly different.
What You’ll Need
- Excel for Microsoft 365 on Windows, or Excel for Mac if you are following the Mac directions.
- A workbook with the row you want to emphasize. Save the workbook first if you are making a substantial formatting change.
- A fill color in mind. A light shade is usually easier to read behind text and numbers.
No add-in or formula is needed for a one-time highlight. The shortcut selects a row and opens Excel’s built-in fill color options; it does not change the row’s data.
Step-by-Step
- Choose a cell in the row. Click any cell in the row you want to highlight. If you are navigating with the keyboard, move the active cell to that row using the arrow keys. You do not have to select the row before using the shortcut. If the cursor is currently editing text inside a cell, press Esc to cancel the edit or Enter to finish it, then continue. Excel shortcuts can behave differently while a cell is in edit mode.
- Select the whole worksheet row. Press Shift+Space. Excel should show the row as selected across the worksheet, rather than selecting only the active cell. On Windows, if the shortcut inserts a space or does not select the row, click a cell once to make sure the worksheet has focus, then try again. If you are working in an Excel table, check the selection carefully: this shortcut can select the worksheet row, not just the table’s cells.
- Open the Fill Color palette on Windows. Press and release Alt, then press H, then press H again. This is a sequence of key presses, not a combination you hold down all at once. The first key opens Excel’s ribbon Key Tips, and the next keys open the Home tab’s Fill Color palette. A small palette of theme and standard colors should appear.
- Choose the color. Use the arrow keys to move through the palette and press Enter to apply the selected color. If you prefer, use the mouse to click a color. The fill is applied to the selected row. The color shown on the Fill Color button may be the last-used color; opening its dropdown lets you choose a different shade. For a custom shade, look for More Colors in the palette if it is available in your Excel version.
- Check the result and adjust if needed. Click another cell or press an arrow key to remove the selection outline and inspect the fill. If the row looks too dark behind its contents, select the row again and choose a lighter color. To remove the fill, select the row, open the Fill Color palette, and choose No Fill.
- Use the ribbon if you do not want to use Key Tips. Select the row with Shift+Space, then go to Home > Font > Fill Color and choose a color from the dropdown. The paint-bucket icon may display the current fill color; select its dropdown arrow to see the palette. This method is useful if your Excel layout, keyboard, or accessibility settings make the Alt sequence inconvenient.
- On a Mac, select and color the row separately. Press Shift+Space to select the row, then use the Home tab’s Fill Color dropdown to choose a shade. The Windows Alt, H, H Key Tip sequence does not apply to Mac Excel. If you use Excel for the web, the Windows shortcut and ribbon options can depend on your browser and keyboard settings; use the Home ribbon’s Fill Color control if the shortcut is intercepted.
These steps apply a fixed fill to the selected cells. If you insert new data later or move to another active row, Excel will not automatically move the highlight. For a changing, rule-based highlight, use conditional formatting rather than repeating the manual shortcut.
Common Mistakes
- Pressing the keys as one chord. The Windows ribbon shortcut is Alt, then H, then H. Press and release each key in order. Holding Alt and pressing both H keys together may not activate the ribbon command.
- Using the wrong selection. If you apply the fill while only one cell is selected, only that cell changes. First press Shift+Space and confirm the entire row is selected. Conversely, selecting a whole worksheet row may color cells far beyond the visible data.
- Confusing Fill Color with Font Color. Fill Color changes the background behind the cell contents. Font Color changes the text itself. On the Home tab, use the paint-bucket Fill Color control, not the font-color control marked with an underlined letter.
- Expecting the highlight to follow the active cell. This shortcut applies ordinary formatting; it does not create a moving highlight or a conditional rule. A manually filled row stays colored until you change or clear its formatting.
- Ignoring existing formatting. A fill can make text or borders harder to see, especially in a formatted table. Preview the result and pick a contrasting, readable shade.
Tips
- Use a light fill for readability. Pale yellow, blue, or green often keeps dark text clear. Check the row at normal zoom before applying the same color to many rows.
- Highlight only the data area when appropriate. If you do not want the color to extend across every worksheet column, select the cells containing the row’s data instead of using Shift+Space. Then choose Home > Font > Fill Color. This is a practical option for a compact table with unrelated content elsewhere on the sheet.
- For multiple adjacent rows, select them together. Select a cell in the first row, use Shift+Space, and extend the selection with Shift+Up or Shift+Down as needed before choosing the fill. Check the selected area first so you do not color extra rows by mistake.
- Use a table style for consistent formatting. If your goal is to shade every other row or give a whole table a consistent appearance, click in the table and use its table-style options instead of manually filling one row at a time. Manual fill is best for calling attention to a particular record.
- Keep the keyboard workflow short. Once you know the sequence, the Windows process is select a cell, Shift+Space, then Alt, H, H, and choose a color. The color choice is still a separate action; the shortcut does not automatically decide which shade to use.
Troubleshooting
- Shift+Space inserts a space or has no effect: Make sure the worksheet cell is selected, not the formula bar, a text box, or a cell being edited. Press Esc or Enter to leave edit mode, click the cell, and try again. If you are on a Mac, confirm that Excel is the active app and use the Mac row-selection shortcut, Shift+Space.
- Alt, H, H does not open the palette: Use Excel desktop for Windows and press the keys in order. After pressing Alt, look for Key Tips on the ribbon; if they do not appear, the worksheet may not have focus or another program may be intercepting the shortcut. Use Home > Font > Fill Color as a fallback. On a Mac, use the Home tab dropdown rather than the Windows Key Tip sequence.
- The wrong cells change color: Undo immediately with Ctrl+Z on Windows or Command+Z on Mac. Reselect the intended cells and check the outline before applying the fill again. If only one cell changed, the row was probably not selected; if too many columns changed, select just the data cells instead.
- The color appears to do nothing: Confirm that a fill color—not No Fill—was selected, and click outside the selection to see the result more clearly. If conditional formatting or a table style is also applied, its appearance may affect what you see. Check the rule or style before changing the fill repeatedly.
- You cannot find the desired shade: Open the dropdown arrow beside Fill Color rather than clicking the main paint-bucket button. Browse the theme colors or use More Colors if offered. If the workbook uses a custom theme, its palette may differ from the examples shown in other workbooks.
Frequently Asked Questions
What is the shortcut to highlight a row in Excel?
On Windows, press Shift+Space to select the row, then press Alt, H, H in sequence to open Fill Color. Choose a shade and press Enter. The color choice is not automatic.
Does Shift+Space apply a color?
No. It selects the entire worksheet row. You must then use the Fill Color palette or the Home ribbon to apply a background color.
What is the Mac shortcut for highlighting a row?
In Excel for Mac, use Shift+Space to select the row, then choose a color from the Fill Color dropdown on the Home tab. The Windows Alt, H, H sequence is not the Mac equivalent.
Can I highlight only the cells with data instead of the entire row?
Yes. Select the cells you want to shade, rather than selecting the whole row with Shift+Space, then choose Home > Font > Fill Color. This avoids coloring unused columns.
How do I make the highlight follow the row I click?
The manual shortcut creates a fixed fill and does not track the active cell. For an automatic or changing highlight, set up conditional formatting with a rule suited to your worksheet, or use a purpose-built macro if you need more control.
How do I remove a row highlight?
Select the row or cells, open Home > Font > Fill Color, and choose No Fill. If the color came from conditional formatting or a table style, remove or edit that rule or style instead.
Related
- Find the Audit Trail in Excel: Changes and History
- Find and Delete Duplicates in Excel: A Step-by-Step Guide
- Find and Replace Hard Returns in Excel Step by Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Reverse Text to Columns in Excel: How to Recombine DataYes. To reverse Excel’s Text to Columns operation, combine the resulting cells with a formula such as =TEXTJOIN("…
- How to Delete Gaps in Excel: Remove Blank Cells and RowsTo delete gaps in Excel, select the relevant cells, use Home > Find & Select > Go To…
- COUNT in Excel: Count Numbers in a RangeTo count numeric cells in an Excel range, use =COUNT(A2:A20) when your values are in A2:A20. COUNT includes…
- Excel Data Validation: How It Works and When to Use ItIn Excel, Data Validation is a feature that controls what users can enter in selected cells; it is…
- How to Change the Microsoft Outlook View and LayoutTo change the Microsoft Outlook view, open the View tab and select a layout or view option. In…
- Excel Data Modeling: How It Works and When to Use ItExcel data modeling means organizing related information into structured tables and connecting them so you can analyze the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.