View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default Find and Replace one row only

Just select the range and then Ctrl+H (for replace)

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Nick Wakeham" wrote in message
...
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