---
title: "Using range names for model clarity"
canonical: "https://modelassist.epixanalytics.com/space/EA/26575287/Using%20range%20names%20for%20model%20clarity"
format: markdown
---
Models can grow to a size that make them difficult to follow, and Monte Carlo models can be somewhat more confusing because the numbers keep changing. Naming variables is standard practice when using coding languages, but it is less used in Excel models. Range naming in Excel is a great way to make reading formulas more natural, and easier to check.

 

To give a name to a cell or range of contiguous cells, select the cell(s), click in the name box (empty box on the top-left of Excel), and type the name you want to use. So, for example, Cell A1 might contain the value 22. Giving it the label "Peter" means that typing "=Peter" anywhere else in the spreadsheet will return the value 22.

 

Note that a Cell or Range may have several names, and a Cell in a Range may have a separate name from the range's name.

 

 

 

---