How to keep/stop random numbers from changing in Excel?

In the article, we’ll investigate two compelling strategies to stop or keep the random numbers that we have inserted randomly in the worksheet from changing the values that the users have to analyze the data or random numbers in Microsoft Excel. The users must keep or stop the random numbers by using the Ku-tools tab that must insert the numbers between the two random numbers. This method may be completed utilizing a straightforward way within Microsoft Excel by using the Insert Random Data to change the numbers.

Example 1: By using Calculation options

Step 1

Deliberate the Excel worksheet. Open the Microsoft Excel sheet and insert the data from cells A1 to D8 as you need as shown below.

Step 2

In the Excel sheet, locate the pointer and select all the random numbers then press the ctrl+c tab to copy the range and select any other cell to paste it. Press the ctrl+v tab to paste the random numbers to another cell as shown below.

Step 3

Place the pointer within the Formulas tab and connect to the tab that has countless options encompassed. On the Formulas tab, place the pointer and connect to the Calculation Options tab which has the drop-down menu. In the menu, choose and enable the option Manual tab in the Calculation group that will not automatically change the calculation and the formulas will not calculate as shown below.

Example 2: To stop random numbers from changing in Excel by using Ku-tools

Step 1

In the Excel sheet, we have to keep or stop the random numbers from changing. Select the range, and locate the pointer within the ribbon dataset. Place the pointer within the Ku-tools tab and connect to the tab that has countless options encompassed. On the Ku-tools tab, place the pointer and connect to the Insert tab that has the drop-down menu. In the menu, choose and enable the option Insert Random Data tab in the Editing group that will open the dialog box as shown below.

Step 2

In the dialog box, place the pointer in the "From:" input type and enter the value 5 then place the pointer in the "To:" input type and enter the value 60 which will change numbers from 5 to 60 random numbers. Then check and enable the option "Unique Values" and click on the "OK" button. In the sheet, the selected range of random numbers will be kept from changing with the numbers, it will be changed between the numbers 5 to 60 as shown below.

Conclusion

In this article, step-by-step instructions are given to keep or stop the random numbers from changing their values by using the Calculation Options and by using the Ku-tools tab. The users created random numbers to keep the changes from entering the different random numbers. By using Ku-tools, we have entered the two numbers where the random numbers will be changed between those numbers.