Thread: Freezing cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
tjtjjtjt
 
Posts: n/a
Default Freezing cells

You can convert them into numbers.
Copy the cells with the formulas.
Then choose Paste Special on the Edit menu. Click Values and click OK.



--
tj


"Qban" wrote:

I have some cells with numbers that rely on formulas with random numbers. Is
there a way to save those values and make the cells independent of the
formulas used to make them so that they do not continue to recalculate every
time I type something?