Freezing contents of a cell

  • Thread starter Thread starter Barney
  • Start date Start date
B

Barney

I have a cell (A4) that copies the results of a formula in another cell
(B8). When B8 changes, I want A4 to keep its original results. Is this
possible?
Thanks, Barney
 
Yes, have a look at the freeze pane function. It takes a cell co-ordinate
and freezes on the cell.

--
Regards,
Alvin Bruney

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc
 
Barney

Remove the formula from A4.

Copy>Paste Special>Value>OK>Esc.

OR just overtype the value that is currently in A4.


Gord Dibben Excel MVP
 
Thanks to all. I think I'll do a small macro to perform what Gord or Dave
suggested. Those will work just fine, thank you.

Alvin, I used a poor choice of words when I said "freeze". I really want to
lock in the value in A$ before the formula changes it again.

Barney
 
Back
Top