Browse » Home
Friday, January 25, 2013
How to: Find and Replace in Excel 2007
1. Open Excel 2007. Open the spreadsheet you want to edit.
2. Press the 'Ctrl' and 'H' keys simultaneously to open the 'Find and Replace' dialog box. Click the 'Find' tab.
3. Type the string of characters you want Excel to find into the 'Find What' input box.
4. Click 'Find Next' to find the next instance of the character string, or click 'Find All' to find all instances of the string.
5. Click the 'Replace' tab. Type the characters you want to find into the 'Find What' input box.
6. Type the replacement text into the 'Replace With' input box.
7. Click either 'Replace Next' or 'Replace All' to replace the characters one at a time or en masse, respectively.