Solved

Quickly Create Named Cells

Posted on 2011-09-15
3
248 Views
Last Modified: 2012-05-12
I am looking for a way to quickly create named cells in excel 2010.  In the cell I want to name I entered the desired "Named Cell"  but don't know a formula change the text in the cell to the name.  I need to add 100's of unique named cells.  Ranges will not work.

Text in Cell                           Desired Cell Name
Grinding_CBS_11      Grinding_CBS_11
Grinding_CBS_12      
Grinding_CBS_13      
Grinding_CBS_14      
Grinding_CBS_15      


0
Comment
Question by:RyanReese
3 Comments
 
LVL 17

Accepted Solution

by:
andrewssd3 earned 500 total points
ID: 36545853
There is a shortcut to create names in adjacent cells:  if type a name like Grinding_CBS_11 in A1 and a value in B1, then select both cells and press ctrl-shift-F3 you get the Create Names from Selection dialog, which allows you to name the cell B1 with the name in A1.  It works with multiple rows, so you could put your names in  column A, and random values in column B, and your names would be created in column B.  This sounds confusing, but give it a try.
0
 
LVL 7

Expert Comment

by:m4trix
ID: 36545854
That's easy to do, the trouble is determining which are the cells you want to have as named cells and which you don't. If the sheet is blank EXCEPT for cells you want as named cells, then that might be a solution...

Another option might be to set a macro to a key combination that will set the currently selected cell to be named the same as its contents... so for example if it's cell C5, just select it and press "CTRL+L" (or whatever)...

The VBA code to do the latter is simply:
ActiveWorkbook.Names.Add Name:=Selection.Text, RefersToR1C1:="=" & ActiveSheet.Name & "!R" & Selection.Row & "C" & Selection.Column

Open in new window

0
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 36545946
Hello,

enter the list of names one column to the LEFT of where you want the named cells to be.

Then select the cells with the names and the neighbouring cells to the right.

Use "Create from Selection" on the Formulas ribbon or the keyboard shortcut Alt - I - N - C

Tick only the option "Left column" and hit OK

cheers, teylyn
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Compare 3,000cells with each one of 500,000 cells, how? 83 47
Auto Populate Day Month  2 digit Date 4 16
Excel formula Sumif not working 4 27
Excel VBA 4 26
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question