• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 309
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

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