Named range in Excel

A named range is a name that stands in for a cell, a block or a formula, so a reader sees a word where the reference would otherwise be.

Names make a formula legible, but they also hide the address: a formula referring to a name tells a reviewer nothing about which sheet the number came from without opening the name manager.

Auditing tools generally treat names as untraceable, which is one of the reasons a review has to check them separately.

More definitions

Twenty-five terms a reviewer needs, each in one sentence followed by the context that matters.