Display Value of cell, not formula

[Gef]

Hello,

I need to edit a cell in which a formula has been applied. When I click on the cell or (cells) only the formula is displayed. How can I edit the cell, and still have the formula apply to the cell?



Thank you in advance for help on this!

Gef

[gebobs]

The cells display the formula when clicked on but not otherwise?

Please attach your file.

[Gef]

Thank you for your quick response.

The actual value displays. That works correctly. It's not an issue with the formula, I just need to copy and paste rows with the formula. I don't know how to edit the spreadsheet once formulas are in place. Can this be done?

Thanks,

Gef

[gebobs]

Do you mean to edit the formulas once copied? Sure. Either double-click the cell and edit the formula there or select the cell and edit it in the formula bar.

May I ask why you need to edit it? It may be just that you need to properly reference cells in your formula prior to copy/paste.

For example, if your formula refers to A1 and you copy it down, Excel will automatically refer the next cell down to A2. However, if you want the formula to always refer to A1, all you need to do is put a $ in front of the 1 in A1 in the first formula i.e. A$1.

Similarly for copying across. if you want to hold the referred cells column, put a $ in front of the A i.e. $A1. Finally, if you want it held to A1 in either direction - up, down, left, right - put a $ in front of both i.e. $A$1.