Define custom range names using Name Box and Ctrl+F3 to eliminate cryptic cell coordinates.
| Name | Value | Refers To | Scope |
|---|---|---|---|
| TaxRate | 18% | =Sheet1!$B$1 | Workbook |
| DiscountPct | 5% | =Sheet1!$B$2 | Workbook |
| Q3_Revenue | $450,000 | =Sheet1!$C$2:$C$100 | Workbook |
| LocalDept | Dept List | =Payroll!$A$1:$A$10 | Payroll Sheet |
A named range assigns a human-readable label (like `TaxRate` or `SalesData`) to a cell or range of cells.
5 questions on Ctrl+F3, F3 paste names, and scope rules