This procedure will work if the only error that appears is #VALUE!
Select column F
Click on Special
Select Constants (or formulas, depending if the error is a constant of is a result from a formula), and leave checked ONLY Errors.
Hit Control -
Select Entire Row