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.