Excel.Tips.Net ExcelTips (Menu Interface)

Defining a Name

Names are used so that you can refer to a single cell or a cell range using something meaningful to you. You can define a name using Excel's menus by following these steps:

  1. Select the cell or cell range you want the name to represent.
  2. Choose Name from the Insert menu, and then Define from the resulting submenu. Excel displays the Define Name dialog box. (See Figure 1.)
  3. Figure 1. Define Name dialog box.

  4. Replace the suggested name (if any) with the name you want to use for the cell or cell range you selected in step 1.
  5. Click on Add. Your name is now defined.
  6. Click on OK to close the Define Name dialog box.

The names you define in Excel can be up to 255 characters in length and contain any numbers or letters, as well as the period, backslash, question mark or underscore. Names cannot contain any other special characters, including spaces. In addition, names must start with either a letter, backslash or the underscore.

You can also define a name by using the formula bar. To use this method, follow these steps:

  1. Select the cell or cell range you want the name to represent.
  2. Click in the area at the very left of the formula bar.
  3. Type the name you want to define, pressing Enter when done.

The name is defined and appears in the formula bar area whenever the cell or cells are selected.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2044) applies to Microsoft Excel 97, 2000, 2002, and 2003.

Related Tips:

Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!


Leave your own comment:

  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*What is 5+3 (To prevent automated submissions and spam.)
           Commenting Terms

Comments for this tip:

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.