A human-readable name assigned to a cell or range so formulas read like words instead of coordinates.
Try it with AIA named range lets you call A2:A100 "Sales" so a formula reads =SUM(Sales) instead of =SUM(A2:A100). Names are easier to read, audit, and reuse across sheets.
Select the range, type a name in the Name Box (left of the formula bar), and press Enter.
Errors