Using names: the bottom line

If you are going to use a cell or range more than once in Excel, name it!

This rule will save you headache and heartache in many situations! Name everything possible!

  • Ranges you will print
  • Ranges you will format
  • Cells you will use several times in formulas
  • Variables, assumptions & constants
  • Data ranges used in lookups and pivot tables
  • Ranges used for data entry validation
  • Ranges linked to other workbooks, documents, or presentations.
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.