Using Find & Replace

In Excel find and replace are both useful functions. Use find and replace in Excel to locate specific information in Excel 2016.


  1. Open our practice workbook.
  2. Click the Challenge tab in the bottom-left of the workbook.
  3. Crystal Lewis was married and changed her last name to Taylor. Use Find and Replace to change Crystal's last name from Lewis to Taylor. Be careful to only change Crystal's last name!
  4. Find and replace Bio with Biology. Be careful not to change the major Biomedical Engineering!
  5. Use Find and Replace All to replace the Physics major to Physical Science.
  6. When you're finished, your worksheet should look like this:

    Find and Replace Challenge