Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freezing cells
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Freezing cells | Excel Discussion (Misc queries) | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |