instead of always referring to cells in a formula by the row and column references, you could create which of the following to help make it easier to use the cell ranges in a formula?

a$.$

Conditional formatting

b$.$

Named range

c$.$

Formatting

d$.$

Views