Excel First

Excel Solutions

Name Manager

now browsing by tag

 
 

Working With a Defined Name

What is a Defined Name?

 

In Excel, you have the option to assign a Name to a cell, or to a Range of cells. This name is reffered to as a Defined Name.

A Defined Name will give more flexibility than before, you can refer to it in your formulas, or chart series.

Also, the name can be located anywhere in your workbook, you don’t need to use cell or range references.

Read More