How to Name a Cell or Cell Range in Excel 2013?

Microsoft Excel 2013 provides the feature of giving name to an individual cell or the range of cells. This function makes our work easier when we make formulas. In Microsoft Excel we can assign name to a cell, table, and constant, range of cells or formulas. With the help of creating names formulas can easily be understand and managed by ourselves.

Named ranges can also be used to handle abundant data in huger worksheets. We used these ranges in formulas rather than typing and showing the particular cells. When we give name to any cell or range, by default Excel uses an absolute reference for the name which is always according to us. We can view the reference in the new Name dialogue box.

Name of cell or range can be create and used in two different types those are defined name and table name. Defined name show cells, formulas, range of cells and constant while Table name exhibits the Excel table, which is a collection of data save in rows and columns.

Now in this article we will learn how to name a cell or range using New Name dialogue box, have to follow these steps

Name a Cell or Range by New Name dialogue box:

• Open Microsoft Excel 2013
• Select > Cell or Range which we want to name.
• Click > Formulas tab.
• Go to > Define Name button.
• New Name Dialogue box will appear, type the name for the reference.
• In the Scope edit box, Select > Workbook from drop down arrow.
• If we want to add any description, Enter in the > Comments box.
• Click > Collapse and Expand dialog button to select different cells and type equal sign(=) followed by the formula or any constant value.
• Finally Select > OK button.