Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
How to make Excel Defined name in Excel file
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
Type a name in the Name Box
The Name Box in Excel is the fastest way to create a named range:
Select a cell or a range of cells that you want to name.
Type a name into the Name Box.
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:
Go to the Formulastab > Defined Names group, click Name Manager. Or, just press Ctrl + F3 (my preferred way).
In the top left-hand corner of the Name Managerdialog window, click the New… button:
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.
- 1. Create unique name tags with a name tag template Word
- 2. Name Manager: A Quick Way to Name a Cell in Excel
- 3. Excel Formula: How to Get the Excel File Name from Path
- 4. How to make Excel Formula Sheet Name in Excel
- 5. How to make First Name and Last Name in Excel Using Formula
- 6. Name Box: How to add table name in Excel