To reference part of a worksheet in formulas or graphics by cell addresses or range addresses,you have to use a named range.

Name: To reference part of a worksheet in formulas or graphics by cell addresses or range addresses,you have to use a named range.
Brand: Quizplus
Rating: 4.8 (42 reviews)

Question

Quizplus · Accepted Answer

You can reference parts of a worksheet in formulas or graphics by directly using cell addresses or range addresses without necessarily creating a named range. Named ranges are optional for easier reference and readability.

To Reference Part of a Worksheet in Formulas or Graphics