• 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
0
rjfields
Asked:
rjfields
  • 2
1 Solution
 
reitzenCommented:
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.
0
 
reitzenCommented:
If you are not using 2007 or 2010, the menu items would be:

Insert > Name > Create
0
 
rjfieldsAuthor Commented:
Worked great.  Thank you very much
0
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