Define and Use Names in Formulas

What it is

Assigning meaningful names to cells, ranges, or constant values transforms cryptic formulas into readable ones and makes spreadsheet logic easier to share with colleagues. This official reference explains how to create names in the Name Box and Name Manager, scope them to a worksheet or workbook, and apply them in formulas to replace hard-to-follow cell address references.