How to Auto Highlight Column / Row or both of Active Cell in Excel (English) - Best Excel Trick

#MSExcel #ExcelTricks #

In excel when we are working on huge and confusing data, and we need t compare something, it is quite challenging to keep focus on relevant row or relevant column. This may lead to error or mistake.
Solution of this problem is discussed in this tutorial. It is discussed in this tutorial that how to enable auto highlight of column or row or both of active cell in excel. This will ease to compare data. This solution will increase efficiency, reduce chances of error and help to get rid of problem of keep focusing.

Below is link to download file / template discussed in this tutorial.

[ErikSummers]

I have looked all over for something like this.... great creative approach! Thank you!

[billb]

Great video, just wish this worked for the whole Worksheet instead of just a Sheet.

[iqcnblr]

Perfect!! This is exactly what I've been looking for!

[tazguy]

This only works if your workbook allows macro code, and you’re not stepping on other events that are already coded.

[technoobs]

thanks for this, it came handy in my workplace great help

[gustavocortico]

This should be a core functionality of excel.

[smb]

If you highlight a column for example RED- can u select a cell and change it from RED to GREEN. No value would trigger this- the spreadsheet tracks dates only.

[elleb.]

Hi, thanks for making this video .Can I ask why when I click save it always ask for save as?

[Dave_perry]

Is there any way through which I can apply it on Mac?

[uniquedve]

Works great. But is it normal that the "ctrl + z" (Undo) stops working properly?

[AzharKhan-kdbf]

Hi could any1 help me as the steps suggested above are not working at my end no row or column gets colored on selection

[smiljanicn]

this should be a fkn option in M$ Excel

[CalYeMusicLuvr]

I'm curious - This is working fine on the sheet 1 tab, but I have 6 other tabs it is not including. Do you have a video to expand on that?

[carolrooney]

to remove color from selected cell to make it even more visible.... =AND(ROW()=$A$1, COLUMN()=$B$1) - formatted to no color