Find and Replace in selected cells only

davidws

New member
Joined
Sep 8, 2011
Messages
8
Reaction score
0
Points
0
I have been trying to do a find and replace on selected cells only, but it seems to replace in the entire sheet, although not consistently. Can't quite seem to nail down when it does the whole sheet and when it just does the selected cells. Any suggestions on ensuring that replace only takes place on selected cells?
Thanks
David
 

JoePublic

Super Moderator
Staff member
Joined
Sep 16, 2011
Messages
219
Reaction score
0
Points
16
Location
UK
Excel Version(s)
2016
If you only have one cell selected, it will do the whole sheet. Also make sure you don't have the option to search the whole workbook selected.
 
Top