| Home |
| Search |
| Today's Posts |
|
#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? |
| 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 | |||
Threaded Mode
