I am using Excel 2007.

How can I carry out a Find and Replace on the one row that I have
highlighted? The only options I can find are to Find and Replace everything
in the sheet or the workbook. Is there not a way of carrying out this on
just the selected cells or rows?

Nick