You are here

Home

17 - Name Manager in Excel

Name Manager in Excel has a very handy use in building formulas or in Excel programming. The purpose of this function is to name a range of cells.

Example:

We want to sum profit of all companies in our database. At first we have to select Companies Profit range and name it by typing Range Name in program left corner command line.

Then we will build the formula in the following way:

=SUM(PROFIT) – this definiton is the same as =SUM(A2:A13)

Ranges in Excel

Managing already crated names (delete, edit, etc.)  is possible in Excel Name Manager in Menu: Formulas – Name Manager

Name a range in excel

This tutorial explained how to use names in Excel. We hope that you have found it useful and that you will use it to improve your Excel skills. 

Partner sites:

kosime.sk
Kosenie trávy, čistenie pozemkov a záhradnícke práce