Exam 77-420 Microsoft Excel 2013 2. Create Cells and Ranges 2.1 Insert Data in Cells and Ranges: Find and Replace Data

Record the Steps The Macro Recorder is ready, although you will not see a little media player or device.   Go through the steps to Find, Replace and Format the text. The Macro Recorder will follow your actions.   2. Try it: Find and Replace Text The sample spreadsheet is open. The Macro recorder is playing. Go to Home->Editing->Find & Select. Go to Replace. Find what: Cold Platter Replace with: Pita Platter   Keep going... Memo to Self: The Macro Recorder tracks when the steps are right as well as when you make a mistake. You may wish to practice the steps a couple of times before you start the Macro Recorder. Home->Editing->Find & Select->Replace