Excel - find and replace in selected area only

[kevinonearth]

Hi,

I've a large one worksheet workbook and I want to change one thing in a formula which is copied across hundreds of cells.


But I only want to change this in certain selected areas.


But when I use the find and replace option I do not have the option to look in a selected area.


I can only look within Sheet or within Workbook


How can I find and replace in selected area only?

Thank you

 

[SirJB7]

Hi, kevinonearth!

First select the range where you want to perform the replace operation, then select Replace All at the dialog prompt.

Regards!

 

[Montrey]

Use your mouse to select the area.

Press Ctrl+H

Do your thang