Defined name (Named range)

Excel glossary definition

A human-readable name assigned to a cell, range, constant, or formula.

Definition

Defined names make formulas easier to read and maintain. For example, =SUM(Sales) is clearer than =SUM(B2:B100). Manage them under Formulas → Name Manager.

Back to Excel glossary