# 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..

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

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

### 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.

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

## 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.

### Picture Categories

On the Webdingds sheet, I've grouped the pictures into 5 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.

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.

### 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 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.

## Get Sample Files

 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

 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

 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

 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