Lightweight utility to automatically create sheet-scoped Names for selected cells based on their left-hand neighbors.

The built-in Ctrl+Shift+F3 keyboard shortcut, which invokes the Formulas > Defined Names > Create from Selection command, always creates names at the workbook-global scope. To the best of this author's knowledge, there is no built-in functionality for automatically creating worksheet-scoped names. This add-in attempts to rectify that omission.

To use, select the cells for which names are to be created and press Ctrl+Shift+N. The name applied to each cell will be created from the value of the cell to its immediate left.

The binary .xlam file for each release can be found on the GitHub page for that release.

Copyright (c) Brian Skinn 2019

License: The MIT License
See LICENSE.txt for full license terms.

Sheet-Scoped Name Generator is third-party software, and is neither affiliated with, nor authorized, sponsored, or approved by, Microsoft Corporation.