CTRL + F3 will display the Name Manager in Excel.
To create - add list on separate sheet, highlight list and type name in cell name (top left corner).
To link to a drop-down choose Data > Data Validation, in pop-up box choose =listName in the source field.
No comments:
Post a Comment