Named cells

Copper Contributor


I have named a number of cells with one name to address the cells.

Is there any number of a maximum of cells with one name?



1 Reply


In Excel, the number of named ranges (or named cells) you can create is quite large, but it is not unlimited. Here are the key points regarding limits on named ranges:

Excel allows up to 1,048,576 named ranges per workbook. This is the same as the maximum number of rows in an Excel worksheet, reflecting the large capacity Excel has for named ranges.