You could hide all the other rows you do not want to see.
Or you could try Data|Form if you are not using too many fields in that row
Or maybe you could create a userform to show the data from the row you want to see.
Take a look at John Walkenbach's enhanced data form:
The source code is available for a small fee ($20 USA, IIRC). So you can modify
it as much as you want.