How to Highlight Active Row and Column in Excel Automatically (Excel 365 + Older Versions)

Опубликовано: 21 Май 2026
на канале: Spreadsheet Mode

Learn how to automatically highlight the active row and column in Excel.

In this tutorial, I’ll show you:
✔️ how to highlight the active row in Excel 365
✔️ how to highlight the active row in older Excel versions
✔️ how to highlight both row and column
✔️ how to remove the highlight
✔️ common save issues and how to fix them

🧮 Formulas for Older Excel Versions:

Highlight active row:

=ROW()=CELL("row")

Highlight active row + column:

For European regional settings (semicolon):

=OR(ROW()=CELL("row");COLUMN()=CELL("col"))

For US/other regional settings (comma):

=OR(ROW()=CELL("row"),COLUMN()=CELL("col"))

⚡VBA Code

Target.Calculate

⏱️ Timestamps:

00:00 Intro
00:15 For Excel 365
00:42 Older versions — highlight active row
02:00 How to remove highlight
02:12 Older versions — highlight active row and column
02:42 Save errors explained

🔗 My templates & socials:

🛍 My templates: https://alexaplanners.com/
📷 Instagram: / spreadsheet.mode
🎵 TikTok: / spreadsheetmode
📌 Facebook: https://www.facebook.com/share/17RMCt...