Excel Not Highlighting Rows? Fix the Selection and Rules

Errors & fixes · Updated November 18, 2026

If Excel is not highlighting rows, first check whether you are selecting the row or expecting a formatting rule to color it: click its number at the left, or press Shift+Space with a cell in that row selected. If you want rows shaded automatically, check the conditional-formatting rule or table style; for a live highlight that follows the active cell, use View > Focus Cell if your Microsoft 365 version includes it.

First identify what “highlighting” should mean

Excel uses “highlight” for several different effects, and the right fix depends on which one is missing. Selecting a row temporarily marks it as selected. A fill color changes the worksheet’s formatting and remains after you click elsewhere. Conditional formatting applies color when a rule is true, while a table style can shade alternating rows. Focus Cell, where available, emphasizes the row and column around the active cell as you move through the sheet.

These effects are independent. A row can have a yellow fill but still show a subtle selection overlay, and selecting a row does not automatically apply a permanent fill. Before changing settings, click a row number and see whether the whole row is selected. Then click a different cell: if the color disappears, it was selection shading; if it stays, it is formatting.

Select a whole row and check the selection display

To select one complete worksheet row in Excel for Microsoft 365 on Windows, click its row number in the gray headings along the left edge. Alternatively, select a cell in the row and press Shift+Space. The selected row should be visually marked across the worksheet grid, and a border or shading indicates the selection.

  • To select multiple adjacent rows, drag across their row numbers or select a cell in the first row, hold Shift, and select a cell in the last row before pressing Shift+Space.
  • To select nonadjacent rows, hold Ctrl while clicking their row numbers on Windows.
  • To select a range of cells rather than entire rows, drag across the cells or use Shift with the arrow keys.

If only one cell is outlined, that may be the active cell rather than a full-row selection. Click the row heading itself or use the shortcut again. On Mac, Shift+Space also selects the row in many Excel keyboard configurations; Mac system shortcuts and keyboard layouts can affect combinations, so clicking the row heading is a reliable alternative. Excel for the web also supports selecting a row from its heading, though browser and keyboard settings can influence shortcuts.

Excel does not make the selection color the same thing as cell formatting. If you need a strong, lasting color, apply a fill or conditional formatting rather than relying on the temporary selection shading. A selected cell range can also look less distinct when the worksheet is zoomed out or the selection covers a large area; check the row heading and active-cell border to confirm what is selected.

Use Focus Cell for a highlight that follows the cursor

If your goal is to keep track of the current row while moving between cells, look for Focus Cell on the View tab. In supported Microsoft 365 builds, View > Focus Cell highlights the active cell’s row and column, so the emphasis moves when you select another cell. This is different from filling a row: it is a viewing aid, not a permanent change to the workbook’s cell formatting.

If Focus Cell is available but not producing the effect you expect, make sure it is turned on and that you are looking at the active worksheet. Some versions offer a dropdown beside the command for changing the focus color. The feature’s availability and controls can depend on the Microsoft 365 update channel and build; if the command is missing, install available Office updates or use a conditional-formatting or table-style approach for persistent shading. Do not confuse Focus Cell with Freeze Panes: freezing keeps selected rows or columns visible while scrolling, but it does not highlight the active row.

Check conditional formatting rules

Conditional formatting is a common cause when certain rows should turn a color but do not. The rule may apply to the wrong range, refer to the wrong column, use a different status spelling, or be overridden by another rule. On Windows, select a cell in the affected area and go to Home > Conditional Formatting > Manage Rules. In the “Show formatting rules for” list, choose the current selection or worksheet to inspect the relevant rules.

For example, suppose the data occupies A2:G100 and the status is in column D. To shade each entire row when its status is Complete, select A2:G100 and create a rule using Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. With statuses in D2:D100 and the rule applied to A2:G100, use =$D2="Complete". Choose a fill under Format, then confirm the rule. If D2 contains Complete, row 2 meets the condition; a different value does not. The dollar sign locks the status column while the row number adjusts for each row.

Check the rule’s “Applies to” range in Manage Rules. If it says only =$D$2:$D$100, Excel will format the status cells, not the rest of each row. It should cover the full intended data range, such as =$A$2:$G$100. Also inspect the formula for the correct status column and starting row. Extra spaces, different wording such as “Complete ”, or a formula referring to the header row can prevent the expected match.

Rules can overlap. In Manage Rules, examine their order and whether “Stop If True” is selected for a higher rule. A rule above another one may determine the visible formatting, depending on the formats and settings involved. If the rules are confusing, record or screenshot them before making changes, then edit or remove only the rule that applies to the affected range. Conditional formatting is not available in the same full form in every Excel interface; the exact controls can vary in Excel for the web and Mac.

Confirm that the row has not simply lost its fill

If a color should remain even when you click away, check the cell fill. Select the affected cells and open Home > Fill Color. A fill can be applied to selected cells, a whole row, or a range; selecting the row heading first applies a manual fill across the row’s worksheet cells. If the fill is absent, reapply the intended color. If a conditional-formatting rule controls that area, its displayed format can take precedence over the ordinary fill, so inspect the rule as well.

To remove a manual fill, use Home > Fill Color > No Fill. Be careful not to choose Clear All unless you intend to remove more than the color: that command can also remove other cell contents or formatting, depending on what is selected. If you only want to remove conditional formatting, select the relevant cells and choose Home > Conditional Formatting > Clear Rules, then select the option for the selection. Clearing rules removes those rules; it does not repair a rule that needs a corrected range or formula.

Another useful distinction: Home > Clear > Clear Formats removes cell formatting, including fills and many other formats. It is broader than changing the fill color alone, so use it only when resetting the formatting is appropriate. If the problem concerns just one color, the Fill Color control is usually the narrower choice.

Check table banding and row styles

Excel tables often shade alternating rows using a built-in table style. If the banding has disappeared, click inside the table and open the Table Design tab. Confirm that Banded Rows is selected, then inspect the chosen style in the Table Styles gallery. A style with very subtle alternating colors may technically be working but hard to see on your display or printout.

If your data is only a plain range, you can select it and choose Home > Format as Table, then pick a style. Excel asks whether the range has headers; answer according to the layout. A table expands more conveniently when new rows are added and can provide filters and consistent formatting, but converting a range into a table changes how Excel treats that data. If you do not want a table, conditional formatting can shade alternating rows instead. With data starting in row 2 and the rule applied to the complete data range, a formula such as =MOD(ROW(),2)=0 marks even-numbered worksheet rows. Choose a fill for the rule; because the test uses worksheet row numbers, the first shaded data row depends on where the range starts.

Look for hidden rows, filters, or sheet protection

A filtered list can make it seem as though Excel is skipping rows. Filters hide records that do not match the current criteria; they do not necessarily remove them. Check the filter arrows in the header and clear or adjust the relevant filter. Also inspect the row numbers: if the sequence jumps, some rows may be hidden or filtered out. Select the neighboring row headings, right-click, and choose Unhide when rows were manually hidden.

Worksheet protection can restrict formatting changes. If you can select cells but cannot change their fill or edit conditional formatting, check Review > Protect Sheet. A protected sheet may allow some actions and block others, depending on the permissions chosen when protection was enabled. You need the appropriate password or permission to change protection settings; protection is not itself a setting that turns off row-selection shading.

Finally, verify that the cells you expect to be colored are inside the table, fill range, or conditional-formatting “Applies to” range. Data pasted below a table or beyond a rule’s last row may look like part of the same list while lacking the same formatting. Extending the table or rule to include the new rows is often the real fix.

When the highlight still looks wrong

Use a small test before rebuilding a complex workbook. Select one affected row, apply a distinctive fill to a few cells, and click away. If that fill remains, Excel can display formatting and the issue is likely the original rule or style. If the fill appears but a conditional-formatting color differs, inspect the rules. If selecting the row does not visibly mark it, try selecting just one cell and then the row heading, and check whether Focus Cell or another view aid is affecting what you see.

  • Check whether the worksheet is active and whether the row is visible rather than filtered or hidden.
  • Check the “Applies to” range and the order of conditional-formatting rules.
  • Check whether a table style is enabled and whether its banding is subtle.
  • Try the workbook in the desktop Excel app if you are using Excel for the web; some commands and controls differ.
  • Save a copy before making broad formatting changes, especially when the workbook contains many rules or shared templates.

When a coworker sees a different selection appearance, remember that selection shading is temporary and can be perceived differently across displays and Excel interfaces. Cell fills and conditional-formatting results are part of the workbook’s formatting, while the active selection is an interface state. For a dependable visual cue that remains in the file, use a clear fill, a well-designed table style, or a conditional-formatting rule.

Frequently Asked Questions

Why does Excel highlight only one cell instead of the whole row?
Click the row number at the worksheet’s left edge, or select a cell in the row and press Shift+Space. Clicking a cell alone selects only that cell; it does not select the entire row.

How do I highlight the active row automatically?
In supported Microsoft 365 builds, turn on View > Focus Cell. It emphasizes the row and column of the active cell as you move. If the command is unavailable, use a table style or conditional formatting for fixed or rule-based shading; those approaches do not necessarily follow your cursor.

Why is my conditional formatting not coloring the entire row?
Check that the rule’s “Applies to” range spans every column you want shaded, not just the cell containing the condition. For a formula rule, confirm that its row reference starts on the first row of that applied range and that it checks the correct column.

Why did my row highlight disappear when I clicked elsewhere?
That was probably selection shading, which marks the current selection temporarily. To keep color after selecting another cell, apply a fill, use table banding, or set up conditional formatting.

Can I highlight every other row without making a table?
Yes. Apply conditional formatting to the intended range with a formula based on MOD and ROW, then choose a fill. The starting row of the selected range determines which rows appear shaded, so preview the result before applying it to a large sheet.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.