Seeing Names not Cell Ref While Editing Formulas
Seeing Names not Cell Ref While Editing Formulas
(OP)
I assign descriptive names or variable names to cells that store my input data or my formula results. I might use the letter L for the length of a beam that is stored in B25.
When I edit a cell fomula that has L in it, the variable name immediately changes to B25. That may be OK if my fomula is in D25 but not for a formula in D75.
Is there a setting in Excel 2007 that will retain the cell names while editing a formula?
When I edit a cell fomula that has L in it, the variable name immediately changes to B25. That may be OK if my fomula is in D25 but not for a formula in D75.
Is there a setting in Excel 2007 that will retain the cell names while editing a formula?





RE: Seeing Names not Cell Ref While Editing Formulas
=====================================
(2B)+(2B)' ?
RE: Seeing Names not Cell Ref While Editing Formulas
RE: Seeing Names not Cell Ref While Editing Formulas
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
Chinese prisoner wins Nobel Peace Prize
RE: Seeing Names not Cell Ref While Editing Formulas
I opened another spreadsheet not currently being used and my problem reappeared in that sheet. I will upload a "problem sheet".
I always save my files in the '97-2003 file format.
RE: Seeing Names not Cell Ref While Editing Formulas
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
Chinese prisoner wins Nobel Peace Prize
RE: Seeing Names not Cell Ref While Editing Formulas
I am not sure what those options actually do, but I no longer saw the names in the formulas. However, The cells still retained their names, so I used "Apply Names" and now I am in business.
Thanks, you saved my sanity!