A descriptive label assigned to a cell, range, constant, or formula to make it easier to reference in calculations.
جرّبه بالذكاء الاصطناعيDefined names act as aliases for specific Excel elements, replacing complex cell references like 'Sheet1!$A$1:$A$10' with readable text. They improve formula clarity, reduce errors, and make workbooks easier to maintain by providing context to data ranges.
Naming the range A1:A10 as 'SalesData' allows you to use '=SUM(SalesData)' instead of '=SUM(A1:A10)'.
Defined names make formulas easier to read, understand, and update compared to cryptic cell references.