Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 306
  • Last Modified:

Excel - Assign range names to adjacent cells in a single operation

Can each name in a list of names in one column be assigned as range names to the cell adjacent to each name in one action similar to the Range/Label/Right command in Lotus 1-2-3?  Thanks
  • 2
1 Solution
Yes.  Highlight your two columns and the rows then select Formulas > Create from Selection in the "Defined Names" ribbon group.

"Left row"should already be selected for you (select it if not).

There you have it.
If you are not using 2007 or 2010, the menu items would be:

Insert > Name > Create
rjfieldsAuthor Commented:
Worked great.  Thank you very much

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now