You need to use a technique called automation to have Access control the Excel application via VBA.  Then you can use VBA to select a row in the active Excel worksheet, which is pretty simple to do:

     Worksheet(2).Select
     Worksheet(2).Rows(20).Select

This code takes you to the second worksheet and selects the 20th row (see picture below).

But to use this code you first need to set up automation in Access, which is a big topic that involves a lot more code.  It is covered by Richard in one of his more advanced courses.  Search this site for "automation".

Is it Developer 39? When I search for automation, it gives me 39.

I don't have access to Richard's courses, unfortunately, so I can't verify the exact videos you need to see.  The picture below is a sample code to show what automation roughly entails -- you create object variables for various Excel objects: application, workbook, worksheet, range, cell, etc., and then you edit and control the data with VBA in Access, as if the users were manually using Excel themselves, hence the term "automation."