Hi,

If a formula refers to a range of cells, dragging a cell value may not keep
the correct reference. The formula may no longer be correct. Therefor it is
recommended that you copy those cells and paste it to a different location
using the Copy command from the Edit menu, or press the CTRL key and drag
copy of the cell withou copying the content of the cell to the clipboard.

Thereafter, select the cell and right-click, and then click Clear Content.
This way the formula will still refer to the empty cell value with out
showing a incorrect value.

Challa Prabhu


"Oldjay" wrote:

I want to keep a formula the same even if I move one of the cells that it
referenced.