Highlight the Selected Cell’s Row and Column in Excel Without VBA
Question details
Highlight the selected cell’s row and column in Excel without using VBA.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants a spotlight effect that follows the active cell as they navigate a worksheet.
- Observed behavior
- The active cell’s row and column should be highlighted whenever the selection changes.
Open the workbook in Excel and check the View tab for Focus Cell. The feature is available only in supported Microsoft 365 builds.
Enable Focus Cell in Excel
Use the native feature to highlight the active row and column without macros.
Open your workbook in Excel and select the worksheet where you want the spotlight effect.
On the ribbon, select View > Focus Cell.
Click a cell or use the arrow keys to move around the worksheet. The highlight follows the active row and column.

Follow the active cell with WPS Spreadsheet Reading Layout
WPS Spreadsheet’s Reading Layout can highlight the active row and column as you navigate, providing a spotlight-style view without VBA.
- 1. Open your workbook: Launch WPS Spreadsheet and use Open to select your Excel workbook.
- 2. Enable Reading Layout: On the View tab, select Reading Layout to turn on the row and column highlight.
- 3. Navigate the sheet: Click different cells or use the arrow keys to move the active selection and its highlight.
- 4. Turn it off when finished: Select View > Reading Layout again to disable the highlight.

Frequently Asked Questions
Where can I find Focus Cell in Excel?
In a supported Microsoft 365 build, open the View tab and select Focus Cell. If it is missing, check File > Account > Update Options for updates.
Why doesn’t conditional formatting follow every cell selection?
Selecting a cell does not necessarily recalculate worksheet formulas. Rules based on CELL("row") and CELL("col") may update after recalculation, but they are not a dependable way to respond to every selection change.
Can older Excel versions create a fully dynamic spotlight without Focus Cell?
A fully dynamic custom spotlight generally requires an add-in or a VBA Worksheet_SelectionChange procedure. Conditional formatting alone is not a reliable substitute for a selection-change event.
Does the WPS spotlight require macros?
No. In WPS Spreadsheet, select View > Reading Layout to highlight the active row and column without VBA.




