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:
Tips:
| 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. |