How to make the lottery effect in excel?

php editor Apple teaches you how to achieve the lottery effect in excel! The lottery function can be easily implemented through excel's random number function and conditional formatting. With simple settings, you can simulate the lottery process in Excel, which is suitable for various lottery activities and random selection scenarios. Next, we will introduce in detail how to use excel to achieve the lottery effect, making the lottery process simpler and more interesting!

1. First, create and open a blank excel table. We select multiple cells and perform merge and center operations.

2. Select the cell and enter the formula =INT(RAND()*(100-1 1)) 1. Press the Enter key to confirm. We must remember to Enter the = sign together. If the number we randomly select is drawn from 1-50, replace 100 in the formula with 50. In other cases, just modify the data in the formula according to the actual situation.

3. At this time, we need to adjust the display, select the cell, and adjust the font size in the "Home" tab.

4. If we want to randomly draw lots, press the F9 key on the keyboard to refresh. That is, new numbers will appear every time we press the F9 key. If we press and hold the F9 key, it will still appear. The effect of digital scrolling appears!

#Have you learned how to create the excel lottery effect? Isn’t it interesting! Office software can not only make our work smoother, but also bring us different little pleasures. If you are interested in this function formula, you can try this Excel lottery production!

The above is the detailed content of How to make the lottery effect in excel?. For more information, please follow other related articles on the PHP Chinese website!