excel Naming columns and rows

Excel lets you name complete rows and columns. In the preceding figure, the name Qtr_1 is
assigned to the range B3:B6. Alternatively, Qtr_1 could be assigned to all of column B, Qtr_2 to
column C, and so on. You also can do the same horizontally so that North refers to row 3, South
to row 4, and so on.
The intersection operator works exactly as before, but now you can add more regions or quarters
without having to change the existing names.
When naming columns and rows, make sure that you don’t store any extraneous information in
named rows or columns. For example, remember that if you insert a value in cell C7, it is included
in the Qtr_1 range.