How do you lock a cell in excel

importdistributors

Senior member
Sep 14, 2004
294
0
0
When using the =(cell letter number) Like =A7 how do I make it so that once the value is in the field I can delete whatever was in A7 but it would not change in the field?
 

NeoV

Diamond Member
Apr 18, 2000
9,504
2
81
f11 takes you to the VB editor

To convert a formula to a value, copy-paste special - value