Spreadsheet issue

An interesting problem. I keep a spreadsheet of books I assign for review, with columns for title, author, reviewer, etc. When I have to update a row, I search for title or author, etc. The find action will locate the information I'm searching for and highlight the cell, but the other cells in the row don't align correctly -- the Title row, for example, is highlighted, but the Author row, etc., are for a completely different title. It's very frustrating. Is there a fix for this? Thanks.