Create Bingo Cards in Excel

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.

Bingo04

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.

Bingo01

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))

Bingo03

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.

_____________________

Related Posts Plugin for WordPress, Blogger...

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

7 comments to Create Bingo Cards in Excel

  • Ernesto Torres

    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?

  • Juan

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

  • Eric Gallichant

    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.

  • Patricia Parsons

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

  • António Branco

    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?

  • Simon Paraka

    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

  • Wendy

    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!

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>