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.

Head to Excel Home -> Search and select Replace. Enter a typo in the Find bracket. Replace it with the correct term and click Replace All at the bottom.