Finding and Replacing Data

• Excel worksheets contain more than one million rows of data
• You can locate specific data on a worksheet by using the find and replace dialog box
• If your looking for cells that the entire cell value matches the value you're searching for you can click on the options button to expand the find and replace dialog box
• Use find for data you specify
• Use replace for substituting one value for another
• Change a value by hand select the cell and then type a new value in the cell or on the formula bar you select the value you want to replace and type in the new value
• Find what field contains the value you want to find or replace
• Find all button selects every cell that contains the value in the Find what field
• Find next button selects the next cell that contains the value in the find what field
• Replace with field contains the value to overwrtie the value in the find what field
• Replace all button replaces every instance of the value in the find what field with the value in the replace with field
• Replace button replaces the next occurence of the value in the find what field and highlights the next cell that contains the value
• Options button expands the find and replace dialog box to display additional capabilites
• Format button displays the find format dialog box- used to specify the format of values to be found or replaced
• Within list box enables you to select whether to search tha active worksheet of entire workbook
• Search list box selects whether to search by rows or columns
• Look in list box selects whether to search cell formulas or values
• Match case check box requires that all matches have the same capitalization as the text in the find what field- when checked
• Match entire cell contents requires that the cell contain exactly the same values as in the find what field
• Close button closes the find and replace dialog box