Office Settings & Configuration

Highlight the Active Cell’s Row and Column in Excel 365

Huma Ashraf ChHuma Ashraf Ch Nov 18, 2026 871 views

Question details

The user wants Excel 365 to highlight the row and column of the active cell without changing to a dark Office theme.

How to Highlight the Active Cell’s Row and Column in Excel 365
Product
Microsoft Excel 365
Device & OS
not provided
Scenario
Navigating a worksheet while keeping the active cell’s row and column easy to follow.
Observed behavior
The user wants a moving row-and-column highlight similar to a feature they used in an older version of Excel.
Before you start

Open a worksheet in Excel and check the View tab for Focus Cell. Feature availability can depend on your Excel version and update channel.

Solution 1Recommended

Turn on Focus Cell in Excel 365

Use Excel’s built-in Focus Cell feature when it is available in your version.

1
Open the View tab

Open your workbook in Excel and select View on the ribbon.

2
Enable Focus Cell

Select Focus Cell. Click different cells to check that the highlight follows the active cell’s row and column.

3
Choose a color

Open the Focus Cell menu and select Focus Cell Color if you want a different highlight color.

Turn on Focus Cell in Excel 365
Focus Cell not shown?: Go to File > Account > Update Options > Update Now, then check the View tab again. If the feature is still unavailable for your version or update channel, try an add-in.
WPS Spreadsheet

Highlight the Active Row and Column in WPS Spreadsheet

Open your workbook in WPS Spreadsheet and use Reading Layout to highlight the active cell’s row and column as you navigate.

  1. 1. Open the workbook: Launch WPS Office, open Spreadsheet, and select File > Open to choose your Excel workbook.
  2. 2. Find Reading Layout: Select the View tab and find Reading Layout on the ribbon.
  3. 3. Enable the highlight: Select Reading Layout and choose a row-and-column highlight style if prompted.
  4. 4. Navigate the sheet: Click different cells to see the highlight follow your selection. Select Reading Layout again to turn it off.
Follow the active row and column with Reading LayoutOpen and edit Microsoft Excel XLSX and XLS filesWork with a familiar spreadsheet ribbonUse WPS Office for free
microsoft office alternative - wps office

Frequently Asked Questions

Can I highlight the active row and column without using a dark theme?

Yes. On the View tab, turn on Focus Cell if it is available. Otherwise, look for a compatible highlighting add-in under Insert > Get Add-ins.

Why can’t I find Focus Cell in Excel 365?

Focus Cell may not be available in your Excel version or update channel. Try File > Account > Update Options > Update Now, then check the View tab again.

Does changing the Office theme create a moving row-and-column highlight?

No. Changing the theme can affect the appearance of Excel, but it is not a substitute for Focus Cell or an add-in that follows the active cell.

How do I turn off the active-cell highlight?

If you enabled Focus Cell, select View > Focus Cell again. For an add-in, use its ribbon or task-pane controls to disable highlighting.