주 콘텐츠로 건너뛰기

Advanced Find and Replace

Add-in Express

3.5 (6)

Quickly find and replace values or formulas in all selected sheets at once

This add-in enables you to find and replace data in multiple sheets at once. Advanced search options make it flexible and let you narrow down the results to just the records you need:

  • Select the sheets or range for the search

  • Look for values or formulas
  • Make search case-sensitive
  • Find cells that contain only the searched record

The add-in will quickly scan the file and show you a full list of matches grouped by sheet. You can see where the given value or formula is located, see its type, and go to any of the entries by simply clicking on it in the list.

There are two replacement options you can employ: change all found values in a single click, or replace any particular result.

This add-in does not support Excel 2013.

Advanced Find and Replace is perfect to make any kind of substitutions in your online Excel 2016 sheets in seconds.

추가 기능의 기능
이 추가 기능을 사용하는 경우
  • 문서를 읽거나 변경할 수 있음
  • 인터넷을 통해 데이터를 보낼 수 있음
  • https://az158878.vo.msecnd.net/marketing/Partner_21474845602/Product_42949678951/Asset_24659649-d714-4291-a382-59e336bf9e32/findvaluesformulasexcelonline.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474845602/Product_42949678951/Asset_24659649-d714-4291-a382-59e336bf9e32/findvaluesformulasexcelonline.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474845602/Product_42949678951/Asset_e0b6ad53-d5b2-43c0-9137-35fc4e12c790/findreplaceexcelonline.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474845602/Product_42949678951/Asset_509e7a93-5d52-4db0-a50f-fe1b0ad88e83/navigatesearchresults.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474845602/Product_42949678951/Asset_22608ee9-cfa6-4fe4-b4e8-c0ba2b6cbdb6/replacevaluesformulasexcelonli.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474845602/Product_42949678951/Asset_c2f15de6-e722-4f45-9653-b81d6fa8cdb7/Useadvancedsearchoptions.png