How To Highlight A Selected Row In An Excel Table

Randy Austin

Randy Austin

Excel Tables are a great way to view and store all your important data, however viewing the row you have selected is not always obvious when quickly trying to get the information you need. That’s why anytime I create tables in my applications or for my customers, I always program in to Highlight the selected Row in Excel.

This simple programming task add professionalism and great a great user experience to any table in Excel. In the video below I demonstrate exactly how this is done in just a few short minutes
Just open up the Visual Basic Editor (Alt + F11) and place this code in any sheet. (Please make sure you change “E15:K14” to the actual range you want the highlight to appear.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("E5:K14")) Is Nothing Then
Range("A4").Value = Target.Row
End If
End Sub

Please have a look and comment below and share your thoughts. Your Shares, Likes and Comments keep these training videos always FREE

Download Your FREE Workbooks From either of the following links:
Using Your Email Here: http://bit.ly/HighlightRow_Wb
With Facebook Messenger Here: http://bit.ly/HighlightRow_FbDl

Got Excel Question? Let us help you with that, Join thousands of the worlds best Excel Experts in Facebook’s fastest growing @Excel For Freelancers Group right here: http://bit.ly/groupexcel

If you have ever wanted to be able to turn your Excel skill and passion into a lucrative passive income stream then I have just the program for you. 

I have spent the last 7 months putting together the most comprehensive program in which I will share with you all of my secrets that have enabled me to create and sell my Excel applications. 

In this Mentorship Program I will be releasing brand new private video training’s in 90 minute modules made up of smaller lessons. The first application we will be creating together is an amazing Accounting Application consisting of Invoicing, Inventory, Purchase Orders, an Email & Notification Center, Chart Of Accounts, General Ledger, Recurring Transactions, a Full Dashboard and it will have complete Share & Sync capabilities, and much, much more.

I will be sharing every aspect of the process, from concept to cash, including how to Define, Design, Develop and Deploy your own applications. If this sounds like something for you, then NOW is the time join. Lock in your early-bird price before they rise. Click here to join today: http://bit.ly/MentorProgram_WebsiteTues

Share this post

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
Share on email