Excel 가이드

How to use named ranges in Excel

Named ranges replace complex cell references like 'A1:A10' with meaningful labels, significantly improving formula clarity and reducing errors.

단계별

1
범위 선택
Highlight the cells you want to name.
2
Enter the name in the Name Box
Click the Name Box (to the left of the formula bar), type a unique name without spaces, and press Enter.
3
Use the name in a formula
Type your formula and type the name instead of selecting the cell range; Excel will automatically recognize it.

=SUM(SalesData)

Use the 'Name Manager' on the 'Formulas' tab to edit or delete existing named ranges.

Can I use spaces in a named range?

No, named ranges cannot contain spaces; use underscores or camelCase instead.