How to Search for & Replace Word Styles in Excel

Microsoft Excel is a spreadsheet application that allows you to create a range of data for making calculations, charts, graphs, rosters and other types of documents. One of the application's features will find and replace words or numbers used in a worksheet. You also can find words that use a specific style or format. This process operates similarly for both the 2003 and 2007 versions of Excel.

Instructions

1. Open the Microsoft Excel application and then click the "File" option for Excel 2003 or the "Office Button" for Excel 2007. Click the "Open" option.

2. Locate the Excel file you want to work with and then click "Open." Use your mouse to select a range of cells within which you want to search and replace words, or click on a single cell to search the entire worksheet.

3. Click on the "Edit" option (Excel 2003) from the top toolbar menu and click on the "Replace" option. Click on the "Home" tab (Excel 2007) and then click on the "Find and Select" option inside the Editing group. Click "Replace."

4. Enter the word you want to find in the "Find what" field. Click on the "Options" button to further define your search. Click on the "Format" option and select the specific word style from the "Find Format" dialog box. Click "OK."

5. Click on the "Find All" or "Find Next" buttons to search for your word style. Click on the "Replace" or "Replace All" buttons to fully replace the word style throughout your worksheet.

References

• Microsoft Office: Microsoft Excel 2007 Find or Replace Text and Numbers on a Worksheet
• Microsoft Office: Microsoft Excel 2003 Find or Replace Text and Numbers on a Worksheet