Highlight the Active Row While Scrolling in Excel for Mac
Question details
The user wants to highlight the current row or column automatically while navigating a data set 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.
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.
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.
In Excel, open the workbook and select the worksheet containing your data.
Select View > Focus Cell. If the command is not available, check for Office updates or use the VBA method below.
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.

Highlight the active row with conditional formatting and VBA
Use this method when Focus Cell is unavailable or you want a row-only highlight on a specific worksheet.
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. Open the workbook: Open WPS Spreadsheet and choose File > Open to select your Excel workbook.
- 2. Enable Reading Layout: On the View tab, select Reading Layout if it is available in your WPS version.
- 3. Navigate the data: Click a cell or use the arrow keys to move the active selection and follow its row and column highlight.

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.




