Name Manager in Excel 2010

In this article I am going to explain about Name Manager in Excel 2010
  • 3781

Name Manager in Excel 2010

Name Manager is use to defined the specifics name to the cell. After defining the name to the cell we can use this cell by using name.

To define name we have to follow following steps.

Step 1

Open work sheet and select cell which we want to define name.

SelectCellExcel2010.jpg

Step 2

In Formula Tab click on Name Manager.

NameManagerExcel2010.jpg

Step 3

A Name Manager window will be open. Where we click New.

NameManagerDialogBoxExcel2010.jpg

Step 4

A New Name window will be open where we define name of cell and click OK.

NewNameExcel2010.jpg

Step 5

Again Name Manager window will open where we click Close.

NameManager2Excel2010.jpg

Step 6

Name will be created.

Now we can access this cell by Name.

NameManagerResultExcel2010.jpg

Ask Your Question 
 
Got a programming related question? You may want to post your question here
 

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.