Can you use a name range instead of a cell address in a formula in Excel 2016?

Excel

1 answer

Answer

1084952

2026-03-12 19:35

+ Follow

Yes you can. That is part of the reason for having them. It makes referring to cells or ranges easier and makes formulas easier to understand like in the two sets of examples below:

=SUM(A2:A20)

=SUM(Income)

=B20-A20

=Income-Expenses

ReportLike(0ShareFavorite

Copyright © 2026 eLLeNow.com All Rights Reserved.