Finding and Replacing Data

You use the Find and Replace dialog to sweep though and change terms on the Accounts spreadsheet. In reports, you can find but not replace data.

  To use Find and Replace:

  1. From any Strategic Finance view, select the Accounts view.

  2. Select Edit, then Find & Replace.

  3. In Search For text , enter a term, which can be words and/or numbers.

  4. Select an Action:

    • Find — Locates the term.

    • Replace With — Locates and replaces the term with a term you enter here.

  5. Under Search select a scope:

    • All— The whole model.

    • Range—Part of the model.

  6. Optional: Select Match case, and the action is case-sensitive.

  7. Click OK.

  8. Perform an action:

    • Click Replace

      to replace one instance of the term.

    • Click Replace All

      to replace all instances of the term.

    • Click Find Next to skip an instance.

    • Click Close.