CREATE NAME #3: Define a name directly

  1. Choose Insert → Name ? Define.
  2. Type the name.
  3. Enter the new reference in the Refers To box.
  4. Click in the Refers To box then select (click and drag on the sheet). The dialog box will 'collapse' while you select, then will re-expand when you finish selecting. Press the F4 key to cycle between absolute, mixed and relative references.
  5. Click in the Refers To box and type the equals sign ('=') followed by the address or function that defines the name.
  6. Click Add.
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.