Change cell value without chaning formula

  • Thread starter Thread starter Guest
  • Start date Start date
When I click on the cell with name "total", the formula bar show a formula.
When I click on the formula bar to change it name, the formula is gone !
How can I change the "total" to diferent name? without changing my formula
I think this is excel basic but I don't know
Thanks for your help
Daniel
 
Change the value in the cell the formula references.

I have in A1 =B1

B1 is qwerty

A1 reads qwerty

Change B1 to asdfgh and A1 will read asdfgh


Gord Dibben MS Excel MVP
 
Hazarding a thought here ..

You could be referring to a defined/named range called: "total"

Try clicking Insert > Name > Define
The options to change defined names are there
eg In the Define Name dialog, select "total", then edit the name within the
"Names in workbook" box to say "Totalled". Click Add. Then re-select "total"
again, click Delete. Click OK to dismiss the dialog.
 
Could not see "total" in define name?
Daniel

Max said:
Hazarding a thought here ..

You could be referring to a defined/named range called: "total"

Try clicking Insert > Name > Define
The options to change defined names are there
eg In the Define Name dialog, select "total", then edit the name within the
"Names in workbook" box to say "Totalled". Click Add. Then re-select "total"
again, click Delete. Click OK to dismiss the dialog.
Click to expand...
 
Note that a cell *cannot* contain both a formula & a constant value at the
same time. If you delete/type over the formula with say some text, then of
course the formula's gone. Perhaps you were trying to do that?

---
 
Back
Top