Limit Search & Replace's Replace All?

B

Bob

I there a way to limit search and replace's (Ctrl + H) replace all to
just a selected cell range, without using VBA?

I like replace all because it is fast, but I'm concerned about it
changing cells I don't want changed.
 
D

davesexcel

select the range by highliting it,
then find and replace,
this should only replace in the range highlite
 
D

Dave Peterson

And make sure that the selection contains at least 2 cells--else all cells will
be used.
 
S

Saruman

Highlight the cells as previously suggested, once you have run the find all,
then re highlight the same selection and if you click replace all, only the
highlighted cells are replaced.

This is in Excel 2003
 
Top