Fix Excel Row Highlighting and Select the Entire Row
Question details
The user wants Excel to highlight or select the entire row rather than only part of it.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Selecting a worksheet row or displaying row highlighting in a table, PivotTable, or conditionally formatted range.
- Observed behavior
- The highlighting does not extend across the intended row.
Check whether you want to select a whole worksheet row or apply visible formatting across a data range. Note the first and last columns that should be highlighted.
Select the entire worksheet row
Use this method when you need to select a row rather than apply permanent highlighting.
Click any cell in the row you want to select.
Click the row number at the left edge of the worksheet, or press Shift+Space while the cell is selected.
If the selection looks interrupted, check the View tab for Split or Freeze Panes, and check the Data tab for active filters that may affect what you can see.

Extend a conditional formatting rule across the data range
Use this method when a rule colors only one cell or row instead of each matching row.
Check table or PivotTable row banding
Use this method when alternating row colors do not appear as expected in a table or PivotTable.
Select and highlight a full row in WPS Spreadsheet
Open your workbook in WPS Spreadsheet, select the row by its header, and apply a fill color if you want the highlighting to remain visible.
- 1. Open the workbook: Launch WPS Office, open Spreadsheet, and choose Open to select your Excel workbook.
- 2. Select the row: Click the row number on the left side of the worksheet to select the entire row.
- 3. Add a visible highlight: To keep a color on the row, open the Home tab and choose a color from Fill Color.
- 4. Save the workbook: Choose Menu > Save or Save As to save the workbook, including any fill color you applied.

Frequently Asked Questions
How do I select an entire row in Excel?
Click the row number on the left side of the worksheet, or select a cell in the row and press Shift+Space.
Why does my conditional formatting color only one cell?
The rule's Applies to range may cover only that cell. Go to Home > Conditional Formatting > Manage Rules and expand the range to include all columns you want colored.
How can I highlight a row based on a value in column A?
For a range starting at A2, create a conditional formatting rule with a formula such as =$A2="Status" and set Applies to to the full data range, such as =$A$2:$H$100.
Do banded rows highlight the row I select?
No. Banded Rows applies alternating row colors. To select a row, click its row number; to color rows based on a condition, use conditional formatting.




