?
Solved

Quickly Create Named Cells

Posted on 2011-09-15
3
Medium Priority
?
255 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 17

Accepted Solution

by:
andrewssd3 earned 2000 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
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

765 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