Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace cell references with names
I remember that Excel versions before 2007 had a feature to automatically
replace cell references in formulas with names. I have not been able to find this feature in Excel 2007. Does it still exist, or if not is there another way to do it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace cell references with names
Name G3 as Alpha and enter the formula =G3*2 in G4
Select G4 (or the range of cells to be altered) Open the Formula tab on Ribbon; go to Defined Names group; click the launcher (small arrow) on Defined Names too; select Apply If you type = then click on G3 then type *12 the formula will automatically be =Alpha*2 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "hmm" wrote in message ... I remember that Excel versions before 2007 had a feature to automatically replace cell references in formulas with names. I have not been able to find this feature in Excel 2007. Does it still exist, or if not is there another way to do it? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace cell references with names
Thanks Bernard.
A search in help of "apply names" did not yield the relevant result in the top 25 results. Another example of deficiencies in Help 2007. Are you listening, Microsoft? "Bernard Liengme" wrote: Name G3 as Alpha and enter the formula =G3*2 in G4 Select G4 (or the range of cells to be altered) Open the Formula tab on Ribbon; go to Defined Names group; click the launcher (small arrow) on Defined Names too; select Apply If you type = then click on G3 then type *12 the formula will automatically be =Alpha*2 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "hmm" wrote in message ... I remember that Excel versions before 2007 had a feature to automatically replace cell references in formulas with names. I have not been able to find this feature in Excel 2007. Does it still exist, or if not is there another way to do it? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace cell references with names
This is a great place to find XL2007 command when you know the Xl2003
commands http://office.microsoft.com/en-us/ex...491511033.aspx Try the Guide with Insert | Names | Apply -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "hmm" wrote in message ... Thanks Bernard. A search in help of "apply names" did not yield the relevant result in the top 25 results. Another example of deficiencies in Help 2007. Are you listening, Microsoft? "Bernard Liengme" wrote: Name G3 as Alpha and enter the formula =G3*2 in G4 Select G4 (or the range of cells to be altered) Open the Formula tab on Ribbon; go to Defined Names group; click the launcher (small arrow) on Defined Names too; select Apply If you type = then click on G3 then type *12 the formula will automatically be =Alpha*2 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "hmm" wrote in message ... I remember that Excel versions before 2007 had a feature to automatically replace cell references in formulas with names. I have not been able to find this feature in Excel 2007. Does it still exist, or if not is there another way to do it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to replace single cell references with row names? | Excel Discussion (Misc queries) | |||
How to replace single cell references with row names? | Excel Worksheet Functions | |||
Cell References/Names | Excel Discussion (Misc queries) | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
Replace range names with cell references? | Excel Worksheet Functions |