Perhaps you have tried to use Excel to generate a random number for a lucky draw.
That is easy. For example, if you want to generate a random number, you can use the function RANDBETWEEN.
This will give you a random number between 1 and 1000. However, RANDBETWEEN re-calculates whenever there is update to the worksheet. In order words, it keeps giving you a new value when you work on the same worksheet. That is the nature of “Random” but you don’t want this for a lucky draw. As you want to “freeze” the draw result.
On top of your mind may be Copy and Paste Value…. BUT it doesn’t work 😦
Re-calculation occurs before the value is pasted…
No worry! There is a mouse trick to perform the Paste Value action without triggering a re-calculation. Watch this:
What is the trick?
- Select the range of cells
- Move the cursor to a border of the selected range
- When the arrow-cross appears, Right-Click and HOLD
- Drag it to somewhere else and then back
- Release the Right-Click
- Select “Copy Here as Values only”
In short, drag and drop with Right-Click, followed by selecting “Copy Here as Values only”.
As simple as this. 🙂
You may watch it in my YouTube Channel: