Note how the cursor changed to an eyedropper.Ĭ. If the Find and Replace dialog box does not appear like the one above, click on the Options button to expand the dialog box.Īlso note that when you open this dialog box again to locate another type of format, you must click on Clear Find Format from the drop-down menu.Ħ. Click on Choose Format From Cell from the drop-down menu.Ī. When the Find and Replace dialog box opens click on the small arrow next to the first Format button.ĥ. Click on the Find and Replace button located in the Editing groupĤ. Click on the Home tab located in the Office RibbonĢ.
Note: I used Excel 2007 to create this tutorial. In this tutorial we will walk you through steps necessary to find and replace formatting of cells in Excel. You can use this powerful command to locate a formula you wish to update, a set of values that have changed, and the formatting applied to cells. Find and replace allows users to specify elements to locate in a spreadsheet.
One of Excel’s most powerful formatting tools is the Find and Replace command.
