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

"Mike_3333" wrote:

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.

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.

"Teethless mama" wrote:

select your range find what: your criteria Replace with: your criteria
Replace All

"Mike_3333" wrote:

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.

I cannot replicate your problem unless I have OptionsWithinWorkbook
selected.

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


Gord Dibben MS Excel MVP



On Thu, 6 Aug 2009 11:20:06 -0700, Mike_3333
wrote:

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.

"Teethless mama" wrote:

select your range find what: your criteria Replace with: your criteria
Replace All

"Mike_3333" wrote:

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.

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.

"Gord Dibben" wrote:

I cannot replicate your problem unless I have OptionsWithinWorkbook
selected.

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


Gord Dibben MS Excel MVP



On Thu, 6 Aug 2009 11:20:06 -0700, Mike_3333
wrote:

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.

"Teethless mama" wrote:

select your range find what: your criteria Replace with: your criteria
Replace All

"Mike_3333" wrote:

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.

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

On Thu, 6 Aug 2009 17:08:01 -0700, Mike_3333
wrote:

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.

"Gord Dibben" wrote:

I cannot replicate your problem unless I have OptionsWithinWorkbook
selected.

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


Gord Dibben MS Excel MVP



On Thu, 6 Aug 2009 11:20:06 -0700, Mike_3333
wrote:

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.

"Teethless mama" wrote:

select your range find what: your criteria Replace with: your criteria
Replace All

"Mike_3333" wrote:

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.

Yes, you can. You can't just change the cells you select but you can change just cells with certain formatting.

So, select the cells you want to change, then bold all those cells. Then when you open the Find and Replace window, to the right there is a format arrow - click Bold to set that as the format it will look for. Then apply your change (assuming nothing else that might be affected is already bold... if it is, then choose italics or a different font or size or whatever to distinguish the cells you want to change). After the change is done, highlight those cells if they're not still highlighted and change the format back to what you wanted. It's an extra step or two, but it works.

To find and replace data in selected cells only in Excel 2007, follow these steps:

1. Select the cells where you want to find and replace data.
2. Press the Ctrl + H keys on your keyboard. This will open the Find and Replace dialog box.
3. In the Find and Replace dialog box, enter the data you want to find in the Find what field.
4. In the Replace with field, enter the data you want to replace the found data with.
5. Click on the Options button to expand the options.
6. Make sure the Within field is set to Sheet or Workbook, depending on your preference.
7. Select the Match case or Match entire cell contents options if necessary.
8. Click on the Find Next button to find the first occurrence of the data you want to replace.
9. If you want to replace the found data, click on the Replace button. If you want to skip it, click on the Find Next button again.
10. Repeat steps 8 and 9 until you have replaced all the data you want to replace.

That's it! You should now be able to find and replace data in selected cells only in Excel 2007.