Excel tip to highlight row with one click #exceltips #excel #exceltricks

In this video, I'm going to show you a quick Excel tip to highlight rows with one click. This tip is great for fixing mistakes or just making things a little bit easier!

If you're a regular user of Excel, then you know that sometimes you need to highlight a row or column for some reason. This technique is simple and easy to use, and you can use it to fix mistakes or highlight specific information in your spreadsheet. So don't wait any longer, watch this quick Excel tip and learn how to highlight rows with one click!

[markaston]

Worked like a charm. Love it, thank you

[evanskachingwe]

You explained this well. I was able to follow-up with easy. Thank you.

[LovelyJordy]

I just added this to my spreadsheets right now. Thank you!!!

[cz]

This is a feature that should be an option.

[LotisHaroldDolliverTV]

Wow I just did it. Thank you for sharing.

[mansoorahmad]

❤thank you so much 🙏.
I was very tired to make highlights cell but I learn from to see your this video. ❤❤❤❤

[abeltahik]

Great hack. Its will be fun to try it.... ❤

[waleadeniji]

AWESOME!... WORK PERFECTLY
THANX ALOT

[shknayaka]

Ohhh my goddd... It is totally new thing to me.. It's amazing.. Great

[ziagi]

Thank you so much ☺️ it’s really helped me to my work. ❤

[PatricParrot]

This is legit something I just used and made me so happy.

I now know I don't like yellow though

[Yaqoobalvi]

Same can be done for highlight column and row

[jonathanfromohio]

This is awesome. I’ll have to try it. I currently use VBA but it’s clunky and can get messed up when removing rows

[Rice]

Cool!😁👌
I know method with named formula.
But yours one i've liked more. Thanks! 😊

[evilmob]

Legend. I’ll try this out when I get a chance.

[raphaelcheng]

=ROW()=CELL("ROW")
Copy and paste this for the lazy. Watch the video for the additional instructions

[ronaenesio]

I guess I won't be needing my ruler😂
Thanks for the tutorial

[priyavaibhav]

Thnx. PLs COpy =ROW()=CELL("ROW")

[PatricParrot]

There is only one, minor, issue I've noticed.

The added code makes my spreadsheet a bit laggy. It could be because my work pc is a bit of a potato or my spreadsheet has a lot of workbooks which are very populated.

Other than that. Would do it again. I chose baby blue and added a conditional underline to make it extra clear. May remove the colour in fact.

Thank you for the info

[torquettalk]

It worked for me. My problem is that if I close my Excel file and open it again, it doesn't work unless I have to put "Target.Calculate" on the code again. Does this have something to do with Macro and changing the options on Trust Center? I don't know these and I feel stuck.