| 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 | |||
Linear Mode
