EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login

Name Box in Excel

By Madhuri ThakurMadhuri Thakur

Home » Excel » Blog » Excel Tools » Name Box in Excel

Name Box in Excel

Excel Name Box (Table of Contents)

  • How to Give Name in Name Box?
  • How to Edit and Delete the Name of the Data Range?
  • How to Use the Name Box in Excel?

Definition of Name Box in Excel

The box located to the left side of the formula bar which addresses the selected cell or group of cells in the spreadsheet is called Name box. In the below screenshot highlighted with a red color box is the Name box.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

name box in excel 1

This Name box helps to address the group of cells with a name instead of addressing rows and columns combination. This tutorial will cover how to create a Name box and how to use it while working with data.

How to Give Name in Name Box?

Consider a small example of student’s data like below. In the below screenshot Name box representing the selected cell A1.

name box in excel 1-1

Now we will select the student data alone from the table, excluding the header “Students”.

name box in excel 1-2

After selecting the data, go to the name box and type the name which you want to name the data range. Here I am giving the data range name as “Students”. After Inputting the name Press Enter Key, it will create the name.

name box in excel 1-3

Now, whenever we want to select the student’s data range, we can select from the Name box drop down as below.

name box in excel 1-4

If we add the marks data of the students as below.

Popular Course in this category
Sale
Excel Training (21 Courses, 9+ Projects)21 Online Courses | 9 Hands-on Projects | 110+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.9 (11,436 ratings)
Course Price

View Course

Related Courses
Excel Advanced Training (16 Courses, 23+ Projects)

name box in excel 1-5

We already gave the name “students” to column A data. Still, we can give the name to the combined data of students and marks as “Smarks”.

name box in excel 1-6

How to Edit and Delete the Name of the Data Range?

We have seen how to give a name to the data range. Now, we will see how to edit and delete the name.

#1 – Edit the Name of the Data Range

In case if we incorrectly input the name or want to change the name. We gave the name as “Smakrs” for the student data range incorrectly, which should be “Smarks”. Now, we will change the name from “Smakrs” to “Smarks.”

The name box does not have the option to edit the given name; we should change the name in “Name Manager” under the “Formulas” menu. Click on the “Name Manager” to view the available names.

Edit the Name of the Data Range - 1

Click on the option “Edit” on the top.

Edit the Name of the Data Range - 2

So that we will get the below “Edit Name” box.

Edit the Name of the Data Range - 3

Edit the name to “Smark” as required.

Edit the Name of the Data Range - 4

In case if we want to increase or decrease the range of cells, we can change in “Refers to” option.

Edit the Name of the Data Range - 5

#2 – Deleting the Name of the Range

It is as similar to how we edit the name. Click on the “Name Manager”. Select the name of the range which we want to delete. Click on the “Delete” option on the top.

Deleting the Name of the Range - 1

This is how we will create, Edit, and Delete the Name in the name box.

How to Use the Name Box in Excel?

Let us understand how to use the name box with a few examples.

You can download this Name Box Excel Template here – Name Box Excel Template

Example  #1 – Count Formula with Name Box

Suppose we want to count the number of students from the student’s table. We can use the count formula with the name of the range. In the below screenshot, we input only the half name of the range then the system displays the name automatically. Select the name and close the formula.

Count Formula with Name Box - 1

Below you can see the output.

Count Formula with Name Box - 2

As the number of students is five, it should display 5. Remember, it is not COUNT; it is COUNTA formula.

counta excel 3

Example #2 – SUM with the Name Box

Now we will see how to perform the SUM operation using the name feature. Our task is to sum the marks of all the students. In the SUM formula, we will give the range name “Smarks”, which we created earlier, instead of the range B2 to B6.

SUM with the Name Box - 1

After using the formula, the output is shown below.

SUM with the Name Box - 2

So, to replace the range address, we can use the name of the range. The name range will also pop up if we input the first few letters of the name range.

Example 3 – VLOOKUP with Name Box

We have to perform VLOOKUP for Table B to find the marks from Table A.

VLOOKUP with Name Box - 1

Create a name “Sdata” for data in Table A as below.

VLOOKUP with Name Box - 2

Now input the VLOOKUP Formula in Table B.

VLOOKUP with Name Box - 3

Once you select the “lookup_value” as E3, give the table array as “Sdata”, which is the name of data range from Table A as the range has 2 columns, input column index as 2, then input zero(for True).

VLOOKUP with Name Box - 4

Expand the formula to get marks for other students.

Example #4 – Excel Name for Constant

We can use the Excel name feature for creating constant also. We will see one example of this to understand in a better way. Consider a table having data of the number of hours of employees as below.

Excel Name for Constant - 1

The charge per hour will be 20 rupees. So, we will create a constant with the value 20. Click on the Name formulas menu.

Click on the Name Manager, and the below window will appear.

Excel Name for Constant - 2

Click on the “New” option, and it will take you to the below screen.

Excel Name for Constant - 3

Give the name as Rate 20, and in “Refers to” give constant value 20 as below and click on OK.

Rate 20

Now go to our table and input the formula for multiplication with the use of name constant. Start the formula with the Equal symbol and select the number of hours option.

input the formula

Add a Multiplication symbol.

Multiplication symbol

Now give the constant name we created.

Constant Name

Select the Rate20 and Press Enter Key. It will multiply the number of hours by 20.

Multiply the Number

Drag the formula from cell B2 to B5.

Drag the Formuila

Things to Remember About Name Box in Excel

  • While giving the name for a range, make sure there should not be any spaces as it will not take if we input any spaces in between.
  • Don’t include punctuations in the name.
  • The name will be case sensitive; hence, it will be the same whether we give the name “Hai” or “hai”. While calling the range, you can use any case letters.
  • The name should start with a letter or Backslash “\”  or Underscore  “_”. Other than these, if the name starts with any other letter, Excel will throw you an error.
  • The name can be applicable at sheet level or workbook level; it depends on our selection while creating the name in the name manager.
  • The name should be unique as it will not allow duplicate values.
  • The name can be a single character to Eg: “A”.

Recommended Articles

This is a guide to Name Box in Excel. Here we discuss how to use the Name Box in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Count Names in Excel
  2. Excel Named Range
  3. VBA Name
  4. Combine First and Last Name in Excel

Excel Training (18 Courses, 9+ Projects)

21 Online Courses

9 Hands-on Projects

110+ Hours

Verifiable Certificate of Completion

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Primary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (34+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (23+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (21+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

Download Name Box Excel Template

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड Name Box Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

Special Offer - Excel Training (18 Courses, 9+ Projects) Learn More