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".

Solution:

  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.
Next