Find and Replace one row only
 

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

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

Find and Replace one row only
 

Thanks for that - I am just being thick!


"Ashish Mathur" wrote in message
...
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