How do I find/replace data in selected cells only

  • Thread starter Thread starter Mike_3333
  • Start date Start date
M

Mike_3333

I use to be able to find and replace data in "Selected" cells. Now 2007
wants to find replace all in the entire workbook, or sheet.
 
select your range > find what: your criteria > Replace with: your criteria >
Replace All
 
I know how to find and replace, the problem, based on the question is that in
older versions of Excel, you could find and replace on "selected" cells. In
2007, it now replaces every occurance of the "Find" in the entire
sheet/workbook. I need to be able to find and replace in just selected cells
NOT the whole worksheet.
 
I cannot replicate your problem unless I have Options>Within>Workbook
selected.

Try with Worksheet selected in Options after selecting a range of cells.


Gord Dibben MS Excel MVP
 
It still does it. Under options with either sheet, or workbook selected it
still changes all occurances in the current sheet. I can't find anywhere
else to change a setting to only change in selected cells.
 
I know of no setting that would find/replace an entire worksheet rather than
just the selected cells.

With the exception of a setting of "Workbook" as already stated.


Gord
 
Back
Top