Using Find and Replace - Exercise

Contact Us or call 1-877-932-8228
Using Find and Replace - Exercise

Using Find and Replace

Duration: 5 to 10 minutes.

In this exercise you will find and replace text in a worksheet.

  1. Continue working in the workbook from the last exercise or open Dave's Lemonade Stand - Using Find and Replace.xlsx from your Excel2013.1/Exercises folder.
  2. Use Find and Replace to change the word "Payroll" to "Employees".


  1. Open or go to the specified file.
  2. From the Editing group on the HOME tab, select Find & Select and select Replace:Replace Command Under Find and Select
  3. In the dialog box, enter:
    1. Find what: "Payroll"
    2. Replace with: "Employees"
  4. Click Replace All:Find and Replace Dialog Box
  5. Click OK.