Range Names

Narrative1 Range Name Conventions
Excel Range Names for Merging to Word
To get a field (a single cell) or table (range of cells) to Word, name the cell or range with "N1" as the first two characters. For example, N1MyData or N1MyTable.

Charts and Excel 2007
With Excel 2007, named ranges with charts/graphs need to have the word "Chart" in the range name. For example, "N1MyPopulationTrendChart". Otherwise, the chart or graph wont link properly in Word.

To insert the field in Word, run the fields and tables dialog. The name will be included in the list, but without the "N1" prefix for easier reading.

Excel Range Names for Saving Subject Data to Comps Database
Name the cell (ranges cannot be saved to the database) with "N1DB" as the first characters. For example, N1DBCondition. Note that the database must have a field with the same name, less the N1DB prefix (see help). In this example, there must be a "Condition" field in the database.

Important Notes:
  • Cells with N1DB names do not merge to Word. To link to Word, add a second name to the field. For example, N1Condition.
  • If the database field name has a space in it, substitute an underscore. For example, N1DBYear_Built.
  • If the database field name has a front slash "/" in it, substitute a back slash "\". For example,
    Database Name: NOI/SF
    Range Name: N1DBNOI\SF
Generally, Excel wont allow range names with special characters. However, these characters are allowed:
  • Backslash  "\"
  • Periods "."
  • Underscore "_"
  • Numbers are allowed
See Database The Subject for saving the data to the comps database.

  • To find the name of a cell, select the cell, then view the Name box in the Formula bar.

  • Most tables (aka ranges) have the name in the lower left corner in blue text.

  • Each comp sheet has the name in the upper-left corner in light gray text.
  • To find the Excel source for a Word field, open Excel, type Ctrl-g (this opens the "Go To" dialog) and enter the field name, preceded with N1. For example, to find the field "Address" enter "N1Address".  There are two ways to find the field name in Word:
    1. The Word Fields and Tables dialog has a complete list in alphabetical order.
    2. Place the cursor in the field, right-click and select "Toggle Field Codes" (or press Shift-F9). This will reveal the field name.

  • This works for fields and tables. For example, entering N1SalesGrid in Excel's Go To dialog will select the sales grid.

Tip: Help pages can be printed (link at bottom), but hey, we're all going green, so please think twice before printing.

FYI: Screen shots and videos in the this document are a mix of Excel 2000-2003 and 2007.