Menus & Ribbon


This tool will display a list of headers or page thumbnails on the left margin for navigation.


Active Edit
"Mark Active Edit" places a bookmark at the location of the cursor, while "Go to Active Edit" will move the cursor to that location.


Merge Fields and Tables
Simple! click and merge.

The merge will do four things:
  1. Synchronize with Excel. This means getting field and table data from Excel - the process only runs when there is new data to get. If "Save Fields & Tables" has been run in Excel since the last time "Merge Fields & Tables" was run in Word, Narrative1 will will get the new data. A "Synchronizing" message will appear when this is happening.

  2. Merge fields. Field data is always merged as text, such as dates, values, descriptions, etc.

  3. Merge Tables. Tables are Excel ranges, such as grids, comps sheets, etc. If there are duplicate sheets in Excel, multiple Sales Grids for example,merge tables will run more than once.
  4. Merge Maps. Maps are automatically generated with Google Maps for the subject and comps.
Note: Merge Fields will always merge the last Excel file that ran  "Save Fields & Tables". Merge with the wrong Excel file? No problem - simply run  "Save Fields & Tables" from the correct file, then re-run Merge Fields in Word.

FYI: The data only moves one way, from Excel to Word. Use "Edit in Excel" to move from Word to the source field/table in Excel.


Fields and Tables Dialog shade fields mark tables insert field add field update field update table refresh field
The Fields and Tables dialog is primarily used for inserting fields and tables, though a number of other functions are available.

All fields and tables are listed alphabetically - use the "Jump to" to navigate the list.

Insert a Field/Table:
  1. Place the cursor where you want the field/table to be located.
  2. Run the Fields and Tables dialog and navigate to the field/table name in the list.
  3. Click Insert Field/Tbl button.
Update Fields in Headers and Footers (New 9-7-10)
Select this check-box to include field updates for headers or footers.

For information on creating fields and tables, see Range Names.

Shade Fields and Mark Tables (New 1-18-11)
This feature delineates Narrative1 fields and tables in the printed document to facilitate template development. Fields are printed with gray shading and tables are marked with a red boarder on the left margin, enabling the editor to see and better manage the template development process.

New Features for the May 2011 Release
There are three new features with the May 2011 Release (Beta)
  1. The ability to search field list by the field name, or a portion thereof. 
  2. The ability to find fields in the document.
  3. Get New Fields. This utility will modify the fields in the Word doc to reflect new or changed fields in the Excel template. 

Map Fields and Tables
This is utility to map Fields and Tables to a different Excel worksheet. This is designed to make adding multiple sections of the Excel file to the Word document easy. For example, with multiple adjustment grids in Excel (or any Excel sheet), it is typically necessary to have corresponding narrative in the Word document. Here is how the process works:
  1. Copy the sheet in Excel
  2. In Word, copy all the narrative associated with the sheet that was copied in in Excel. For illustration, assume there are two Sales Grids in Excel. In Word, select and copy all the text associated with the Sales Grid, from the introduction to the conclusion, including fields and tables.
  3. Place the cursor at the location where the new narrative for the second Sales Grid should begin.
  4. On Word's main menu, select "Paste and Map Fields & Tables to New Sheet". The Fields and Tables dialog will look like this:

  5. Select the worksheet from the drop-down that will serve as the source for the Fields and Tables in the selected text. 
  6. Click the Map selected fields ... button. A message will display noting how many fields and table have been mapped to the new worksheet, in this example Sales Grid (2).
  • Only original narrative can be re-mapped. In other words, the copied text cannot be copied again and re-mapped to a new worksheet. Expanding on the above example, if the Excel file had three grids instead of two, the narrative text for the first grid would be copied and mapped to Sales Grid (3).
  • Tables: When re-mapping a table in Word, be sure to include a line before the table when selecting the text to be re-mapped.
  • Didn't mean to activate this dialog? Simply click the button at the bottom left side of the form to return to the regular Fields and Tables dialog. 

Edit In Excel
This feature will move the cursor from a field or table in Word to the corresponding field or table in Excel. To jump from Word to Excel, simply click on a field or table, then select Edit in Excel from the Narrative1 menu.


The Narrative1 Autotext is a database system for MS Word sections. A section can be as short as a single character, or many pages in length. It can contain images, tables, links, fields; virtually anything that can be created in MS Word. The section has a maximum file size of 1 megabyte. Note that Narrative1 Autotext is not related to the Microsoft Word Autotext system, which is tied to your workstation. The Narrative1 Autotext system utilizes the same network SQL database system as the comps database, which is the key advantage: Narrative1 Autotext can be accessed from all your computers. Your Autotext entries, of course, are private to your company and only accessible with your database codes. Another significant advantage is the tag system used to organize entries. An entry can have multiple tags, so entries can be efficiently sorted.

Create Autotext
  1. Select the text in Word, then click the Narrative1 menu (top menu, right hand side).
  2. Name the entry and select tag(s) - optional - to associate with the entry.


Insert Autotext
  1. Place the cursor where the autotext will be inserted.
  2. Select "Insert Autotext" from the Narrative1 menu
  3. Select an entry to insert from the list on the right. Use the tag list on the left to filter the entries displayed on the right.


Manage Autotext
Autotext entries are organized by tag associations. This is similar to folders, but several tags can be associated with a single autotext entry. For example, assume there are 10 zoning entries in the system, each one tagged with "Zoning" and a city name. Selecting the Zoning tag will filter the list and display the ten zoning entries. Selecting the city name and tag will then filter the list again and display the zoning for that city. Another example might be selecting the city name tag. This would display all entries related to that city. This might include a market area analysis, zoning descriptions and assessment information.

Tags are user-defined, therefore can be organized around specific locations and types of information specific to your practice.

Tags are created and edited via the Manage Autotext from the Narrative1 menu.

New Feature for the May 2011 release (Beta)
  • Autotext Preview


Subject Photographs in Word
Narrative1 has a picture tool in MS Word. Activate by right-click and select Pictures.

Tip: Help pages can be printed, 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.