Office Settings & Configuration

Highlight the Selected Cell’s Row and Column in Excel Without VBA

Jason MillerJason Miller Nov 18, 2026 874 views

Question details

Highlight the selected cell’s row and column in Excel without using VBA.

Highlight the Selected Cell’s Row and Column in Excel Without 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.
Before you start

Open the workbook in Excel and check the View tab for Focus Cell. The feature is available only in supported Microsoft 365 builds.

Solution 1Recommended

Enable Focus Cell in Excel

Use the native feature to highlight the active row and column without macros.

1
Open the workbook

Open your workbook in Excel and select the worksheet where you want the spotlight effect.

2
Turn on Focus Cell

On the ribbon, select View > Focus Cell.

3
Move the selection

Click a cell or use the arrow keys to move around the worksheet. The highlight follows the active row and column.

Enable Focus Cell in Excel
If Focus Cell is unavailable: Check File > Account > Update Options for available updates. Older or unsupported Excel versions may require a VBA Worksheet_SelectionChange procedure or an add-in for a fully dynamic custom spotlight.
Highlight the active cell

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. 1. Open your workbook: Launch WPS Spreadsheet and use Open to select your Excel workbook.
  2. 2. Enable Reading Layout: On the View tab, select Reading Layout to turn on the row and column highlight.
  3. 3. Navigate the sheet: Click different cells or use the arrow keys to move the active selection and its highlight.
  4. 4. Turn it off when finished: Select View > Reading Layout again to disable the highlight.
Highlight the active row and column while reviewing a worksheetOpen and edit Microsoft Excel XLSX and XLS filesNavigate worksheets with a familiar ribbon interfaceUse WPS Office for free
microsoft office alternative - wps office

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.