Contextures

Print Bingo Cards in Excel

Have some fun with Excel, and print Bingo cards for an office party, or for a game at school or home. Use these Excel Bingo Card templates, and print as many cards as you need.

Author: Debra Dalgleish

Print Bingo Cards in Excel

In this Bingo Card template, there are three cards on the main worksheet, which is named Cards.

Each bingo card has a set of 24 random numbers, with a FREE square in the centre of the card..

bingo card numbers 1 to 75

Numbers Sheet

On another sheet in the workbook, named Numbers, the RAND function is used, to create the random numbers for each bingo card.

On the Numbers sheet, there are 3 sets of lists, with manually entered numbers, from 1 to 75.

In the adjacent columns, the RAND function is entered, beside each of the 75 number.

  • =RAND()

numbers 1 to 75 and rand function

Random Numbers For Bingo Cards

On the number cells for 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))

index and match formula on bingo cards

Different Sets of Numbers

It is possible that the same number might appear on all three cards, but each card uses a separate lookup table of random numbers.

Because of that setup, it is highly unlikely that all 3 Bingo cards should be exactly the same.

Print the Bingo Cards in Excel

The cards are formatted to print three per sheet, on letter sized paper.

To print the first set of 3 cards, follow these steps:

  • Go to the Cards worksheet
  • Press the F9 key, to generate a set of random numbers for each bingo card
  • Print the worksheet (File > Print, or use the Print button on the Quick Access Toolbar)

To print another set of 3 cards, follow these steps:

  • Press the F9 key, to generate a set of random numbers for each bingo card
  • Print the worksheet (File > Print, or use the Print button on the Quick Access Toolbar)

Bingo Cards 1 to 100

There is another Excel bingo card template that you can download, and it has random numbers from 1 to 100.

In the screen shot below, the first number in the O column is 100.

bingo card numbers 1 to 100

This version works the same as the original bingo card template, but the random number sheet has typed numbers from 1 to 100.

Get this version in the download section below.

numbers 1 to 100 and rand function

Excel Bingo Cards With Pictures

For younger people who want to play the bingo game in Excel, here is a version that uses pictures instead of numbers.

Just like the bingo cards with numbers, the RAND function is used to produce sets of 3 unique Bingo cards in this Excel template.

Then, the CHAR function converts the number to a characters, and the Webdings font is used on the bingo cards, to show the selected characters as pictures.

bingo card with pictures

Picture Categories

On the Webdingds sheet, I've grouped the pictures into 5 categories

bingo card picture categories

On the Webdings sheet, here is also a list of character numbers. In the adjacent column, the CHAR function shows the Webding picture for each character code.

The list is sorted by category, and then by character code within each category.

bingo card picture character codes

Then, on the Numbers sheet, the numbers for each category are pasted into its columns.

For example, in the screen shot below, you can see the start of the Fun numbers in columns A, and Nature numbers in column D.

bingo card picture numbers sheet

Unused Pictures

You can choose different Webding pictures for your bingo cards, if you prefer. Just change the character codes on the Webdings sheet, and the Numbers sheet.

I left out some of the really ancient pictures, like the film projector, phone modem and fax machine shown below. Young people might not know that those items are!

bingo card webdings pictures

Bingo Game Number Selector

If you need a number selector for your Excel bingo game, try the Excel bingo board that Chip Gorman created, based on a number selected created by Dick Kusleika (Daily Dose of Excel).

In Chip's number selector, a voice announces each number, when it is selected, and previously selected numbers are highlighted on a bingo board.

bingo number selector

Get Sample Files

bingo cards

Bingo Cards - Numbers 1 to 75
The RAND function is used to produce sets of 3 unique Bingo cards in this Excel template.
Format: xlsx  Macros: No 
Excel File: BingoCard.zip 64 kb

 

FN0068

Bingo Card - Numbers 1 to 100 --
The RAND function is used to produce sets of 3 unique Bingo cards in this Excel template
Format: xlsx  Macros: No 
Size
: 68 kb  Excel File: bingocards100.zip

 

FN0045

Excel Bingo Card With Pictures
The RAND function is used to produce sets of 3 unique Bingo cards in this Excel template. The CHAR function converts the number to a characters, and the Webdings font is used on the bingo cards, to show the selected characters as pictures.
Format: xlsx  Macros: No 
Size
: 30kb  Excel File: bingocardpictures.zip

 

FN0003b

Excel Bingo Number Selector
The RAND function is used to produce sets of 3 unique Bingo cards in this Excel template. The CHAR function converts the number to a characters, and the Webdings font is used on the bingo cards, to show the selected characters as pictures.
Format: xlsm  Macros: Yes 
Size
: 76kb  Excel File: BingoBoard.zip

_____

More Tutorials

Excel Printing Tips

RAND Function

INDEX and MATCH

Last updated: June 16, 2022 8:58 PM