How to make Excel Defined name in Excel file

July 22, 2022
1.2K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

In everyday life, names are widely used to refer to people, objects, and geographical locations. For example, instead of saying the city lying at latitude 40.7128° N and longitude 74.0059° W, you simply say New York City. In Excel, you can create and use two types of names: Defined name - a name that refers to a single cell, range of cells, constant value, or formula. For example, when you define a name for a range of cells, it's called a named range, or defined range.

How to define name

  1. Type a name in the Name Box

The Name Box in Excel is the fastest way to create a named range:

  1. Select a cell or a range of cells that you want to name.

  2. Type a name into the Name Box.

  3. Press the Enter key.

Make a named range by using Excel Name Manager

Usually, the Name Manager in Excel is used to work with existing names. However, it can help you build a new name too. Here's how:

  1. Go to the Formulastab > Defined Names group, click Name Manager. Or, just press Ctrl + F3 (my preferred way).

  2. In the top left-hand corner of the Name Managerdialog window, click the New… button:

  3. This will open the New Namedialog box where you configure a name as demonstrated in the previous section.

How to define Excel name for a constant

WPS excel lets you outline a name without cell reference with a view to acting as a named consistently. To create this kind of call, use Excel's Naming function or the Name Manager.

For example, you may create a name like USD_EUR (USD - EUR conversion price) and deliver it at a set cost. To do this, enter the value earlier than the equal sign (=) within the Refer to discipline.

now this name can help you anywhere in formulation to transfer of currency

As rapid due to the fact the change price adjustments, you replace the price high-quality in a single number one place, and all your method gets recalculated in a single step!

How to define a name for a formula

Similarly, you can create an Excel component with a name, which includes a method that returns the wide variety of non-blank cells in column A, except for the header row (-1):

Now every time you need to recognize what number of entries are in column A on Sheet five, apart from column headers, just type the same signal followed by means of the name of your formulation in any mobile, like this: = Items_count):


Did you learn about how to make Excel Defined name in Excel Spreadsheets? To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets, and PowerPoint Slides.

You can also download WPS Office to edit the word documents, excel, PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.