Excel Name Box | Exceljet

Skip to main content

You are here

Home › Glossary › Name Box Name Box

Related terminology

Named range Formula Bar

In Excel, the Name Box refers to an input box directly to the left of the formula bar. The Name Box normally displays the address of the "active cell" on the worksheet. You can also use the name box to quickly create a named range.

Another use for the Name Box is to navigate quickly to any range in a worksheet. If you type Z100 into the Name Box, the active cell will move to that address. If you type A1:A10 into the Name Box, that range will be selected.

Finally, if you have one or more named ranges in a workbook, the Name Box behaves like a drop down menu. You can select and navigate quickly to any name.

Related Information

Terms

• Named range
• Formula Bar

Articles

• Named Ranges in Excel

Topics

• Formula Basics
• Formula Examples
• Conditional Formatting
• Pivot Tables
• Excel Tables
• Excel Charts
• Shortcuts
• More...

Key Functions

• IF function
• VLOOKUP function
• XLOOKUP function
• FILTER function
• SUMIFS function
• COUNTIFS function
• SUMPRODUCT function
• INDEX and MATCH
• New Excel Functions
• All Excel Functions

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

  

Just a really quick note to say thanks for the "normalize size units to gigabytes" formula -- it's one of the very few times in my 25+ year career that I've found a help page on the net where the suggested solution worked perfectly, unmodified. Ian More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles