Solved

Quickly Create Named Cells

Posted on 2011-09-15
3
249 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VBA to Delete the Filtered Rows in an Excel Table 3 33
Need Help with Mapping and Toggling 3 22
I need help with an EXCEL Nested formula. 5 24
Getting rid of #VALUE! 7 23
INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

829 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