Replace references with names

You can replace references in your sheet with names you've created one of two ways:

  • Using the Apply Name command by choosing Insert → Name ? Apply.
  • Choose Edit ? Replace and, in the Find What box, enter the original address reference. In the Replace With box, type the name.
Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.