You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.
This truly GLOBAL find and replace will help. Say that you have hundreds of similar Excel workbooks in a folder and you need to globally change “2009 Budget” to “2010 Budget” in all of the workbooks.
If you use Excel 40 hours a week (and those are the weeks you are on vacation), welcome to the MrExcel channel. Home to 2,400 free Excel tutorials. Bill "MrExcel" Jelen is the author of 67 books about ...