How to Manage Cell and Range Names (Part-1)-MS Excel 2007…..!!!!!

0

Manage Cell and Range Names ms Excel 2007

Method-1: Name a Cell Range from the Name Box

To name a cell range from the Name box:

            1.       Select the range you want to name.

            2.       To the left of the formula bar, click in the Name box.

            3.       In the text field, type the name of the range and press Enter.

            4.       To select the range and verify that it is correct, click the Name box drop-down arrow and select the range name.

Method-2: Name a Cell Range with the New Name Dialog Box

To name a cell range with the New Name Dialog box:

            1.       Select the range.

            2.       Open the New Name dialog box.

A. On the Formulas tab, in the Defined Names group, click the Define Name drop-down arrow and select Define Name.

B. Or, in the Defined Names group, click Name Manager and then click New.

            3.       In the New Name dialog box, in the Name text box, type the range’s new name.

            4.       If necessary, from the Scope drop-down list, define the range name’s scope.

A. Select Workbook to declare the scope throughout the entire workbook.

B. Or, select a worksheet name to declare the scope for a particular worksheet.

Tips: – By declaring the scope to be a specific sheet, it is possible to use the same name multiple times in a workbook.

             5.       If desired, type comments to describe the range name.

             6.       In the Refers To text box, select what the range refers to.

A. A cell reference, that is, one cell or a group of cells.
B. A constant: (=[number or text]).
C. Or, a formula: (=[formula]).
D. Click OK.

Method-3: Name Cell Range Using Worksheet Data

To use worksheet data to create range names:

            1.       Select the range.

            2.       On the Formulas tab, in the Defined Names group, click Create From Selection.

            3.       In the Create Names From Selection dialog box, in the Create Names From Values In The section, check boxes to use the contents of the top or bottom row or the right or left column of the range as the range names.

            4.       Click OK.

…………………………..Thanks everyone

Share.

About Author

Tonmoy

Leave A Reply

CAPTCHA ImageChange Image