How to make simple number lottery tickets with Excel

Excel has played a great role in our life and study. Sometimes it is necessary to draw lots. Can Excel do it? The answer is yes. This tutorial teaches you how to draw a simple number with Excel.

Excel software for tools/materials

0 1 Create a new Excel blank table and select any number of cells to merge and center.

Adjust the font size and color and add a beautiful background color.

03 Select the cell and enter the formula "= int (rand () * (1000-1+1))+1".

Note: All the contents in quotation marks are entered; If the range is 1- 100, you can change 1000 to 100.

After the above steps are completed, you can draw lots. Press F9 to start refreshing, and a new number will appear every time you press it.

Note: Some computers have different models, so you need to press Fn+F9.