PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO USE NAME MANAGER AND DEFINE NAMES IN EXCEL?

INTRODUCTION

Name Manager keeps the track of all the defined names in Excel.

The Names can be defined by selecting a group of cells and defining their name.

The names are helpful in understanding and making the formulas easier to understand and apply.


Name manager shows all the defined names for the ranges and define names helps to name the range.

BUTTON LOCATION OF NAME MANAGER AND DEFINE NAME IN EXCEL

NAME MANAGER EXCEL

HOW TO DEFINE NAMES IN EXCEL?

It helps to define the names of any cell or range.

Just select the cell or cell range ( A group of cells) and click define name.

Choose the scope, which can be workbook or sheets.

DEFINE NAME IN EXCEL
DEFINE NAME DIALOG BOX

HOW USE NAME MANAGER IN EXCEL?

Name manager shows all the defined names for the ranges and define names helps to name the range.

name manager in excel
NAME MANAGER DIALOG BOX

HOW TO GIVE NAMES AUTOMATICALLY IN EXCEL?

The RANGE NAMES can be given automatically by an option called CREATE FROM SELECTION.

This option gives automatic names from the selection. User need not to give customized names to the range or cells. The excel itself understands and gives the name from the row heading or column heading as per the user’s requirement.

STEPS:

  • Select the cells for which the names are needed including the column heading or row heading, whatever is applicable.
  • Click on the button, CREATE FROM SELECTION.
  • The following screen will appear.

 

GIVE NAMES AUTOMATICALLY IN EXCEL
AUTOMATIC NAME ASSIGNMENT IN EXCEL
  • Choose from the options present in the dialog box. It asks from where the automatic names are to be taken. e.g. we don’t need top row as we need only the marks. So select only LEFT COLUMN AND CLICK OK
  • NOW click on NAME MANAGER to find out how many names have been created. Editing can be done if something is not as per convenience.
AUTOMATIC NAMES EXCEL
NAME MANAGER WITH CELL NAMES

The student names has been given to the marks cells also. Now suppose we need to sum the marks of any two student, Abraham and Ravi. We need not to write =SUM(cell address of Abraham marks, cell address of Ravi marks). In place of this we will simply write =SUM(Abraham, Ravi). This is the benefit of naming a cell. It speeds up the work.

OTHER WAYS TO REACH THIS ARTICLE

  • NAME MANAGER IN EXCEL, NAME A RANGE IN EXCEL, BENEFITS OF NAMING A RANGE IN EXCEL,

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: