View Single Post
  #8   Report Post  
stevesto stevesto is offline
Junior Member
 
Posts: 1
Default

Quote:
Originally Posted by Mike_3333 View Post
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.