Replace text for selected cells only

H

Hall

Is it possible to select specific cells and then have the Replace feature
only apply to those cells, particularly if I use the Replace-All button?
 
D

Dave Peterson

That's the way it works.

Are you experiencing something different?

(one tip. Don't hit the Find all button. If you notice, your selection is lost
when you do that.)
 
D

DJH

Selecting only one cell, and Excel will try to Replace throughout the whole
sheet.

Selecting multiple cells, and Excel will Replace only within the Selected
Cells.
 
Top