Editing Excel formula showing names not cell reference
Editing Excel formula showing names not cell reference
(OP)
Is it possible to edit a formula that displays cell names instead cell references?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
Editing Excel formula showing names not cell reference
|
RE: Editing Excel formula showing names not cell reference
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
RE: Editing Excel formula showing names not cell reference
http://www.quepublishing.com/articles/article.aspx...
In brief:
Type (I)nsert (N)ame (A)pply and select the range names you want to show in the formulas.
In 2010 it's on the Formulas tab, click on the little down arrow to the right of "Define Names" and select Apply Names.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Editing Excel formula showing names not cell reference
Thanks again!
RE: Editing Excel formula showing names not cell reference
So now when I copy one of the formulas, the names are copied and appear in the cell as they should be. Now, if I go to edit the cell formula, the range names remain after I click into the edit window at the top. Great! But if I edit the cell formula a second time, the name disappears and I see the cell address instead.
I have Excel 2007 and I have saved my spreadsheet as a '97-2003 xls file so that I can use it at home with an older version.
Does anyone know what I am doing wrong?
RE: Editing Excel formula showing names not cell reference
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
RE: Editing Excel formula showing names not cell reference
RE: Editing Excel formula showing names not cell reference
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
RE: Editing Excel formula showing names not cell reference