Articles on: Excel

How to highlight row and column when user click on cell



Save workbook as macro enabled



Convert text to table



select all table except header



Conditional formatting, using formula  =COLUMN()=CELL("col")   then format



Again go to Conditional formatting by selecting all table except header, using formula

          =CELL("row")=ROW() then format as desire

![](https://storage.crisp.chat/users/helpdesk/website/198cc7156baff800/674658a3-5cfd-4c8a-8c19-0673ba_10bqzr8.png)

Go to developer, visual basic, double click on your working sheet, click on general and choose worksheet. Write code as Application. Calculate

![](https://storage.crisp.chat/users/helpdesk/website/52145a599512b000/7fece620-9742-4efd-9acb-74ca2a_10gq2ch.png)

Close VBA, if not highlighting, you can use F9 to accelerate once.

Save and close

And enjoy

https://trumpexcel.com/highlight-active-row-column-excel/

Updated on: 31/01/2023

Was this article helpful?

Share your feedback

Cancel

Thank you!