Formatting Issues

Highlight the Active Row While Scrolling in Excel for Mac

Natalie TaylorNatalie Taylor Nov 20, 2026 869 views

Question details

The user wants to highlight the current row or column automatically while navigating a data set in Excel for Mac.

Highlight the Active Row While Scrolling in Excel for Mac
Product
Microsoft Excel for Mac
Device & OS
MacBook Pro, macOS
Scenario
The user is scrolling through a worksheet and wants to keep track of the active cell's row or column.
Observed behavior
The desired result is a visible highlight that follows the active cell as the user selects cells in the data set.
Before you start

Open the workbook in Excel for Mac and check the View tab for Focus Cell; availability depends on your Excel version. Scrolling alone does not change the active cell, so select a different cell to move the highlight.

Solution 1Recommended

Use Focus Cell to highlight the active row and column

Use this built-in feature if Focus Cell is available in your version of Excel for Mac.

1
Open the worksheet

In Excel, open the workbook and select the worksheet containing your data.

2
Turn on Focus Cell

Select View > Focus Cell. If the command is not available, check for Office updates or use the VBA method below.

3
Select cells as you navigate

Click a cell or use the arrow keys to move the active cell. The row and column highlight follows your selection; scrolling without selecting another cell leaves it in place.

Use Focus Cell to highlight the active row and column
Highlight rows in WPS Spreadsheet

Track the active row with WPS Spreadsheet Reading Layout

In WPS Spreadsheet, use Reading Layout, where available, to highlight the active cell's row and column as you select cells.

  1. 1. Open the workbook: Open WPS Spreadsheet and choose File > Open to select your Excel workbook.
  2. 2. Enable Reading Layout: On the View tab, select Reading Layout if it is available in your WPS version.
  3. 3. Navigate the data: Click a cell or use the arrow keys to move the active selection and follow its row and column highlight.
Follow the active row and column while navigating a data setOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceWork with spreadsheets in a free office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't the highlight move when I scroll?

Scrolling changes the visible area but does not change the active cell. Click another cell or use the arrow keys to move the selection and its highlight.

Where is Focus Cell in Excel for Mac?

Look for Focus Cell on the View tab. If you do not see it, check for Office updates; the feature may not be available in your Excel version.

Can I highlight only the active row?

Yes. Apply a conditional formatting formula such as =ROW()=$XFD$1 to your data range and use a worksheet selection-change macro to update the helper cell.

Why isn't the VBA highlight updating?

Make sure the code is in the target worksheet's code window, the file is saved as .xlsm, and macros are enabled. Select a different cell to trigger the event.