Drop-down Lists

Manage Custom Drop-down Lists in Excel
In Excel, right-click and select Lists (or select Lists from the Narrative1 main menu).

New (9-7-10): To automatically populate the list tool with a specific list, place the cursor in the cell with the list, then right-click and select lists.



 
Note: With the 2010 release, lists are now stored in the database, not with the Excel file. Thus, if a list is edited in one Excel file, other files that use the same list will automatically update.



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.