How To Set Up Auto-Highlight Row for Reviewing Excel Spreadsheets


Let's be honest.  Document reviews of Microsoft Excel Spreadsheets are a pain in the - eyes.   In the old days, you could just print them out and use a ruler to keep your eyes focused on the line you are working on.  Today as the data makes it nearly impossible to print them out, you need something similar on your screen to save your place while reviewing them.

There is a little programming involved but don't freak out....if I can do it, you can do it too.

👉Go to top left corner and select the entire worksheet 







👉Click on Conditional Formatting







👉Select New Rule











👉Use a formula to determine which cells to format









👉Format Values where this formula is true:

=OR(CELL("row")=CELL("row",A1))









👉Click on Format, then fill to set the color, press OK


















👉Click OK

Now for the programming:

👉Click on Developer  (if you don't see this option, go to File > Options > customize ribbon > look in the right box and add check in Developer the click OK.)










👉Click on Visual Basic










👉Double-Click on the worksheet you want to add the auto-highlight










👉Change General to worksheet





👉Paste this code in place of what is in the box

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
   Target.Calculate
End Sub






👉Close visual basic windows by clicking on the X










If you want to save this to be available everytime you work in this worksheet, you will need to save it as an Excel Macro-Enabled Workbook (.xlsm)

👉Click File > Save as > Exel Macro-Enabled Workbook (.xlsm)

✋NOTE:  I would recommend saving this as another name such as "Filename_REVIEW.xlsm" instead of the original




Now, wherever you click, the entire row should be highlighted.  

Yes, these may be a lot of steps but if you get this set up correctly you will make the process of reviewing Excel Spreadsheets MUCH better for you and your eyes.








Comments

Popular posts from this blog

What Is Culling?

What Is a PST File?

Game Changers In eDiscovery