Office Connector Web HelpOnline Help

Creating a Named Range
Contents Index

 You can use named ranges in Excel to organize key pieces of information and make your formulas more readable.  It is very common to name individual cells, although you can assign a name to any group of cells on a sheet.  Note that named ranges that point to individual cells also appear in the drop-down Value list for Parameters and Cell References in the Add Condition window.

The Name Box

The most convenient way to work with named ranges is by using the Name Box, located to the left of the Excel Function bar:


The Excel Name Box.

To create a named range,
  1. Select the cell(s) you want to name.
  2. Click inside the Name Box and type the name and hit Enter.

Additional Information

  • Click the drop-down arrow on the right side of the Name Box to display the list of named ranges.
  • Click on any name in the drop down list to navigate directly to that cell.
  • For additional management of your named ranges (deleting a name, changing a name's location, etc),

    • VersionInstructions
    Excel 2007Click the Formulas tab and then within the Defined Names group, click on the Name Manager button to display the Name Manager window.
    Excel 2003 and earlierClick Insert / Name / Define... to display the Define Name window.

See Also



Content updated 12/4/2012
Copyright © 2012 Event 1 Software, Inc.  This documentation may not be copied in full or in part without written permission from Event 1 Software, Inc.