×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Editing Excel formula showing names not cell reference

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?

RE: Editing Excel formula showing names not cell reference

Have a look here:

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

(OP)
Thanks Doug. I was going crazy editing my formulas. As soon as I started to edit one, all of the names disappeared and were replaced with the cell references. I was looking for a setting in the Excel program options and couldn't find it.

Thanks again!

RE: Editing Excel formula showing names not cell reference

(OP)
The problem is back again! My problem seemed to be solved when I went to 'Apply' and clicked on all of the range names. The Ignore Relative/Abosolute box was checked and the Use row and column names box was checked.

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

(OP)
IR: Could I use a regular paste and loose the database corruption if that is the problem? I don't want to loose my formating. I would still have to set up all of my column widths.

RE: Editing Excel formula showing names not cell reference

You can paste special Formulas followed by paste special Formats.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources