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


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


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

Save and close

And enjoy

Updated on: 31/01/2023

Was this article helpful?

Share your feedback


Thank you!