SteveGregory
Structural
Is it possible to edit a formula that displays cell names instead cell references?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Editing Excel formula showing names not cell reference 1
- Thread starter SteveGregory
- Start date
- Status
-
1
- #3
Have a look here:
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
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
- Thread starter
- #4
SteveGregory
Structural
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!
Thanks again!
- Thread starter
- #5
SteveGregory
Structural
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?
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?
- Thread starter
- #7
SteveGregory
Structural
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.
davidbeach
Electrical
You can paste special Formulas followed by paste special Formats.
- Status
Similar threads
