• Skip to main content
  • Skip to primary sidebar
  • Skip to secondary sidebar
  • Skip to footer

Computer Notes

Library
    • Computer Fundamental
    • Computer Memory
    • DBMS Tutorial
    • Operating System
    • Computer Networking
    • C Programming
    • C++ Programming
    • Java Programming
    • C# Programming
    • SQL Tutorial
    • Management Tutorial
    • Computer Graphics
    • Compiler Design
    • Style Sheet
    • JavaScript Tutorial
    • Html Tutorial
    • Wordpress Tutorial
    • Python Tutorial
    • PHP Tutorial
    • JSP Tutorial
    • AngularJS Tutorial
    • Data Structures
    • E Commerce Tutorial
    • Visual Basic
    • Structs2 Tutorial
    • Digital Electronics
    • Internet Terms
    • Servlet Tutorial
    • Software Engineering
    • Interviews Questions
    • Basic Terms
    • Troubleshooting
Menu

Header Right

Home » Excel » Name field in Excel 2010
Next →
← Prev

Name field in Excel 2010

By Dinesh Thakur

An Excel worksheet contains a massive number of cells. If there is little data in the document and all of them are compactly placed in the upper left corner of the document, problems with determining the address of the currently active cell, as a rule, do not arise. However, it is often helpful, and sometimes just necessary, to quickly determine which cell is active. Helpful hints can be found in the name field in the formula bar, which is by default just below the ribbon on the left.

Name field with the address of the active cell

This field displays the address of the active cell. In the figure above, cell A1 is active. Therefore its address is displayed on the left in the corner above the working area.

However, in addition to such an implicit visual utility, the name field is a somewhat functional element of the interface. If you enter a cell address in the name field, this cell will become active. In the figure below in the name field, enter the address of cell C2 (with active cell A1).

The cell address is entered in the name field D2

Cell active D2

After pressing the <Enter> key, cell C2 becomes active.

The same is the case with the allocation of ranges. In figure below shows how the address of a range of cells A2: D3 is entered in the name field.

Enter the address of a range of cells in the name field A1 D5

Highlighted a range of cells A1 D5

Pressing the <Enter> key leads to the selection of this Range.

In this case, the Range’s address of the upper-left cell is displayed in the name field. Let’s leave the range A2: D3 active and do the following procedure: enter the word Range in the name field.

Enter the name in the name field Range for the selected range of cells A1: D5

When selecting a range of cells A1 D5 the name field displays the name of this range

After pressing the <Enter> key, the range A1:D5 will become named, and, as you might guess, the name of this Range will be the word Range entered in the name field. The latter is easy to verify. It is enough to select a range of cells.

A1: D5… In the name field, instead of the address of the upper-left cell of the Range, its name will be displayed.

Cells can also be named. In the figure below, when cell B2 is active, the name Cell is entered in the name field.

When a cell is selected, its name is displayed in the name field if it has one.

Enter the name in the name field Cell for cell B2

When selecting a cell B2 her name is displayed in the name fieldMoreover, if you click on the icon with an arrow on the right side of the name field, a list of named cells and ranges will open.

After choosing a name from the list, we go to the corresponding cell or Range.

Clicking on the arrow icon on the right side of the name field expands the list of named cells and ranges

If you enter the name of a range or cell in the name field they will be highlightedTo navigate to named cells and ranges, you can enter a name in the name field just as you entered an address previously. If the name already exists, the corresponding area will be highlighted. Otherwise, the entered name will be assigned to the currently active cell or Range of cells. The above way of naming cells and ranges is not the only one. Also, Excel can even give proper names to formulas.

You’ll also like:

  1. Working with Excel 2010
  2. Excel 2010 Components
  3. Zoom IN/OUT in Excel 2010
  4. Formatting Cells in Excel 2010
  5. Formatting Worksheets in Excel 2010
Next →
← Prev
Like/Subscribe us for latest updates     

About Dinesh Thakur
Dinesh ThakurDinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular Computer Notes blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps.

Dinesh Thakur is a Freelance Writer who helps different clients from all over the globe. Dinesh has written over 500+ blogs, 30+ eBooks, and 10000+ Posts for all types of clients.


For any type of query or something that you think is missing, please feel free to Contact us.


Primary Sidebar

Excel 2010

Excel 2010 Tutorials

  • Excel - Started
  • Excel - Tour
  • Excel - BackStage View
  • Excel - Entering Values
  • Excel - Navigating Workbook
  • Excel - Save Workbook
  • Excel - Open/Close Worksheet
  • Excel - Managing Worksheet
  • Excel - Managing Data
  • Excel - Rows & Columns
  • Excel - Copy & Paste
  • Excel - Find & Replace
  • Excel - Spell Checker
  • Excel - Zoom In/Out
  • Excel - Paginated View
  • Excel - Insert Comments
  • Excel - Insert Text Box
  • Excel - Undo/Redo
  • Excel - Formatting Cells
  • Excel - Formatting Worksheets
  • Excel - Working with Formula
  • Excel - Quick Access Toolbar
  • Excel - Name Field
  • Excel - Formula Bar
  • Excel - Status Bar
  • Excel - Full Screen Mode
  • Excel - Grid and Indexing Fields
  • Excel - Preferences Window
  • Excel - Color Scheme

Ribbon Tab

  • Excel - Ribbon Tabs
  • Excel - Show and Hide Ribbon
  • Excel - Adding Ribbon Groups
  • Excel - Active Label of Ribbon Group
  • Excel - Customizing the Ribbon
  • Excel - Contextual Ribbon Tabs

Other Links

  • Excel - PDF Version

Footer

Basic Course

  • Computer Fundamental
  • Computer Networking
  • Operating System
  • Database System
  • Computer Graphics
  • Management System
  • Software Engineering
  • Digital Electronics
  • Electronic Commerce
  • Compiler Design
  • Troubleshooting

Programming

  • Java Programming
  • Structured Query (SQL)
  • C Programming
  • C++ Programming
  • Visual Basic
  • Data Structures
  • Struts 2
  • Java Servlet
  • C# Programming
  • Basic Terms
  • Interviews

World Wide Web

  • Internet
  • Java Script
  • HTML Language
  • Cascading Style Sheet
  • Java Server Pages
  • Wordpress
  • PHP
  • Python Tutorial
  • AngularJS
  • Troubleshooting

 About Us |  Contact Us |  FAQ

Dinesh Thakur is a Technology Columinist and founder of Computer Notes.

Copyright © 2023. All Rights Reserved.