It’s Friday, and things are slow at the office. To liven things up, you could create bingo cards in Excel, and organize a game during the lunch hour.

In this example, there are three cards, each with a set of random numbers. You’ll need one of those numbered ball popper machines though, or create a number selector in Excel.

### Make Lists of Random Numbers

To generate the random numbers, there are three sets of lists on the Numbers sheet. In each set, there are typed numbers 1-75, with the formula **=RAND()** in the adjacent column.

### Add Random Numbers On Cards

On the three bingo cards, an INDEX/MATCH formula pulls the numbers from the random number tables. For example, this formula is used in cell E2:

**=INDEX(Numbers!$M$1:$M$15,MATCH(LARGE( Numbers!$N$1:$N$15,ROW()-1),Numbers!$N$1:$N$15,0))**

The same number might appear on all three cards, but each card uses a separate lookup table of random numbers.

### Print the Cards

The cards are formatted to print three per sheet, on letter sized paper. After you print, press the F9 key to generate a new set of numbered cards.

### Download the Sample File

You can download the zipped Bingo Card Excel file, from my web site. Enjoy your lunch hour, and if you create a random number selector, let me know.

_____________________

I am an American currently teaching English in Japan. I would like to use your Bingo Card Excel file to make vocabulary bingo game cards. I want to make cards that display the Japanese translations (using Japanese characters) of English vocabulary words.

Is it possible to modify the random numbers tables to return words or phrases as opposed to numbers?

Yes, create another sheet with numbers in column A. column B and C should be your words, English and Japanese. Then use the Random number rounded to a single digit to lookup using the VLOOKUP function the word that corresponds to that number. Switch between columns B and C to show English or Japanese words.

Hi buddy, I found a good example looking for "mini bingo smart" in google... a blog called "excelminiapps" or something like this. Good luck

This is exactly what I am looking for but I can't figure out how to change the 3-card format. I want 4 cards on top of each other. How do I do that? Copy and paste did not work and I can't figure out how to adjust the formuala for the additional card.

Excellent! This is just what I was looking for to have a team building game in my call center!

Excellent, but to complete your explanation It is possible to know how to make, in excel, call numbers and have a sheet with the numbers already out?

Please show me how to create in a 3X9 card with only 15 numbers in a card and the numbers 1to 90 number base..Please

The 1 to 75 number base is ok and is 5x5 with center empty. I like that.. Thanks

Excellent! Thank you very much for your help!

Because I want to print 240 cards for my wedding used, will the number repeat? Because I only wanted 20 people who can have the prize I prepared. Please can help me?

Thanks!

Thank you! Thank you! Thank you! so very much. Just what I needed for our event. You saved the day!

This is so helpful! Thanks! I'm a librarian and we want to do a Banned Books Week Bingo program and you just made me job a whole lot easier. Thanks again!

Good Day,

This is great. Can you help me, how to create a 4th bingo card? I want to minimize paper use.

Thank you

Thank you this is so helpful - making Bingo cards for a Fundraiser!!!

hi

I would like to use your Bingo Card Excel file to make vocabulary bingo game cards.

Please show me how to create in a 3X9 card with only 15 numbers in a card and the numbers 1to 90 number bas

Thank you for sharing this. I am using this for a community party I am helping to plan. It was so much easier to use this and add pictures to it then trying to create it on my own. I appreciate you sharing this for everyone to use.