Excel 2016 : How to Highlight Row you are Working on

Highlighting the Row you are working on in Excel 2016.

[Mrkientube]

All this years using Excell didn't know this feature was possible. Your video was short, to the point, and well explained.

[wingame]

After reviewing and trying out highight rows from several sites, your lesson I found to be fastest, easiest and most quick if not the best. Thank you!

[WomanWithFemalePelvis]

This should be a regular feature in excel. Thank you for providing this very necessary option. When looking at loads of data across a page, I find myself holding my finger to the row to follow it across.

[followthescience]

This is by far the most uncomplicated ansatz I found for that functionality that I expected to be available in vanilla Excel.

Much cool, very thank!

[thomasmartinelli]

This was great stuff. Saved me a lot of time. I have been using Excel for years and consider myself much better than most, but I never knew I could do this.

[theonlyjacknicole]

You are awesome! You just transformed what used to be a bland file, into a more focused and visually useful one.

[domicius]

I've been looking everywhere for a simple solution to this. Amazing - well done sir, and thanks for sharing.

[johnparker]

Worked perfectly - just what I needed. Video is comprehensive and succinct. Thank you.

[jig]

This is awesome, would have been nice if this was built into Excel but your example is simple and does exactly what I wanted. Thanks for. Sharing.

[ARTACELIS]

This was a very good tutorial.
Q. How do I make this happen on another sheet?
Q. How do I make this a default when opening a new spreadsheet?
Q. When I'm done, how do I clear this rule from the file or as a default?

Once again thank you and very good YouTube.

[VikingRaider]

MAN!! That was EXACTLY what I was looking for, and needed SO badly!!! Thanks dude!!

[jwhite]

Thank you!!! This was easy to follow. To do the same thing with columns, can you just replace "Row" in each step with "Column"?

[amnahs]

Works great but do you have any suggestions on how to keep the undo stack from being cleared by this? Once this code is running, you are no longer able to undo anything on this workbook.

[zachsPlayground]

For those that do not like to type ----

Private Sub Target As Range)
With
.Name = "CurrentRow"
.RefersToR1C1 = "=" & ActiveCell.Row
End With
End Sub

[Mlondon_Art]

AMAZING. Wish there had been a tutorial like this for the Mac version but I piecemealed it together. Thank you!

[guybaker]

thank you, really needed this, my eyes drift when looking at masses of spreadsheet rows.

[themewsnews]

This was great, I was able to replicate this on the first try. You are much appreciated! :)

[bmarley]

This was very useful, however, when I go to another sheet it doesn't work?!

[MUGECalgary]

excelently explained and to the point. PERFECT!!!!

[rgvn]

nice !! so easy and effective thank you !