How to Download and Print Bingo Cards in Excel
Bingo is a fun and popular game that can be played for social or fundraising purposes. It involves matching numbers or pictures on a card with those drawn randomly by a caller. The first player to complete a specified pattern on their card wins the game.
Excel is a versatile and powerful tool that can help you create and print bingo cards easily. You can also use Excel to call out the numbers or pictures, mark off the cards, and keep track of the game progress and winners. In this article, we will show you how to download and print bingo cards in Excel, as well as how to play bingo in Excel.
bingo cards excel download
How to Download Bingo Card Templates in Excel
One of the easiest ways to get started with bingo in Excel is to download free and ready-to-print bingo card templates online. There are many websites that offer different types of bingo card templates, such as:
: This website provides three bingo card templates that have random numbers from 1 to 75, from 1 to 100, or with pictures instead of numbers. You can print three cards per sheet, and each card has a free square in the center. You can also generate new sets of random numbers by pressing F9.
: This website provides a bingo template that has a Next button, which randomly selects the next number from the remaining numbers that haven't been drawn yet. The numbers that have been drawn already will appear in a darker shade on the bingo card. You can also clear the card for the next game by pressing the Clear button.
: This website provides 50 and 100 bingo cards ready to print in PDF format. You can choose from different themes, such as animals, colors, shapes, holidays, etc. You can also customize your own bingo cards by adding text, images, colors, fonts, etc.
You can download these bingo card templates by clicking on the links above, or by searching for "bingo cards excel download" on your web browser.
How to Create Your Own Bingo Card Templates in Excel
If you want to create your own bingo card templates in Excel, you can use formulas and functions to generate random numbers or pictures for each card. Here are some steps you can follow:
How to print bingo cards in excel
Excel bingo card generator with numbers or pictures
Bingo template for Microsoft Excel
Free bingo card templates for excel
Excel bingo cards with random numbers
How to create custom bingo cards in excel
Excel bingo cards with words instead of numbers
Bingo card generator program for excel windows or mac
Excel bingo cards 1 to 100
Excel bingo cards 1 to 90
How to excel at bingo with excel template
Excel bingo cards with webdings font
Bingo caller app for excel
Excel help for bingo card generator
Excel bingo cards with large font
How to save ink and paper with excel bingo cards
Excel bingo cards with four or two cards per sheet
How to shuffle numbers for bingo in excel
Excel bingo cards with free square in the center
How to use index and match functions for bingo in excel
Excel bingo cards with different sets of numbers
How to generate random numbers for bingo in excel
Excel bingo cards with pictures for kids
How to check the winners of bingo in excel
Excel bingo cards with fun and fundraising themes
How to play games in excel with bingo cards
Excel bingo cards with different colors and designs
How to make your own list of words for bingo in excel
Excel bingo cards with formulas and functions
How to use rand function for bingo in excel
Excel bingo cards with categories and subcategories
How to use char function for bingo in excel
Excel bingo cards with symbols and icons
How to use vlookup function for bingo in excel
Excel bingo cards with multiple sheets and tabs
How to use conditional formatting for bingo in excel
Excel bingo cards with sound effects and animations
How to use data validation for bingo in excel
Excel bingo cards with hyperlinks and buttons
How to use macros for bingo in excel
How to use the RAND function to generate random numbers for bingo cards
Create a new workbook Enter the following formula in cell A1: =RAND()*75+1. This will generate a random number between 1 and 75.
Copy and paste the formula to cells A2 to A75. This will create a list of 75 random numbers.
Select the range A1:A75 and press Ctrl+C to copy it.
Select cell B1 and press Ctrl+Alt+V to paste the values only. This will remove the formulas and keep the numbers.
Select the range B1:B75 and press Ctrl+H to open the Find and Replace dialog box.
In the Find what box, enter 0. In the Replace with box, enter 1. Click Replace All. This will replace any zeros with ones, since bingo cards do not have zero as a number.
Select the range B1:B75 and press Ctrl+Shift+F to open the Format Cells dialog box.
Go to the Number tab and select Custom from the Category list. In the Type box, enter 00. Click OK. This will format the numbers with two digits, such as 01, 02, etc.
Select cell C1 and enter the following formula: =RANK(B1,$B$1:$B$75). This will rank the number in cell B1 among the list of numbers in column B.
Copy and paste the formula to cells C2 to C75. This will rank all the numbers in column B.
Select cell D1 and enter the following formula: =IF(MOD(C1,15)=0,15,MOD(C1,15)). This will assign a column number for each number based on its rank, from 1 to 15.
Copy and paste the formula to cells D2 to D75. This will assign column numbers for all the numbers in column B.
Select cell E1 and enter the following formula: =QUOTIENT(C1-1,15)+1. This will assign a row number for each number based on its rank, from 1 to 5.
Copy and paste the formula to cells E2 to E75. This will assign row numbers for all the numbers in column B.
Select cell F1 and enter the following formula: =OFFSET($G$1,(E1-1)*5,D1-1). This will reference the cell in the bingo card that corresponds to each number's row and column.
Copy and paste the formula to cells F2 to F75. This will reference all the cells in the bingo card for all the numbers in column B.
Select cell G6 and enter "BINGO" horizontally, one letter per cell.
Select cell G7 and enter "FREE" in bold. This will be the free square in the center of the bingo card.
Select cell G8 and enter "Card #".
Select cell H8 and enter 1. This will be the card number for this bingo card.
Select cell G9 and enter "Name".
Select cell H9 and enter your name or leave it blank. This will be the name of the player for this bingo card.
Select cell G10 and enter "Drawn".
Select cell H10 and enter "No". This will indicate whether this card has been drawn or not.
Select cells H6 to L10 and press Ctrl+Shift+F to open the Format Cells dialog box.
Go to the Alignment tab and select Center from both Horizontal and Vertical lists. Click OK. This will center-align these cells.
Select cells H7 to L7 and press Ctrl+B to make them bold. This will highlight these cells as column headers for the bingo card.
Select cells H11 to L15 and press Ctrl+V to paste the values from column F. This will fill the bingo card with the random numbers from column B.
Select cells H11 to L15 and press Ctrl+Shift+F to open the Format Cells dialog box.
Go to the Border tab and select a thin line for all the borders. Click OK. This will create a grid for the bingo card.
Select cells G6 to L15 and press Ctrl+1 to open the Format Cells dialog box.
Go to the Font tab and select a font size of 14. Click OK. This will make the bingo card more readable.
Select cells G6 to L15 and adjust the column width and row height as needed. You can also merge and center cells G6 to L6 and G8 to G10.
Select cells G6 to L15 and press Ctrl+C to copy them.
Select cell N6 and press Ctrl+V to paste them. This will create a copy of the bingo card.
Select cell O8 and change the card number from 1 to 2. This will be the second bingo card.
Repeat steps 38 to 46 as many times as you need to create more bingo cards. You can change the card numbers accordingly.
How to use the CHAR function and Webdings font to create bingo cards with pictures
If you want to create bingo cards with pictures instead of numbers, you can use the CHAR function and Webdings font in Excel. Here are some steps you can follow:
Create a new workbook Enter the following formula in cell A1: =CHAR(RAND()*255+1). This will generate a random character from the ASCII table.
Copy and paste the formula to cells A2 to A75. This will create a list of 75 random characters.
Select the range A1:A75 and press Ctrl+C to copy it.
Select cell B1 and press Ctrl+Alt+V to paste the values only. This will remove the formulas and keep the characters.
Select the range B1:B75 and press Ctrl+Shift+F to open the Format Cells dialog box.
Go to the Font tab and select Webdings from the Font list. Click OK. This will change the characters into pictures.
Select cell C1 and enter the following formula: =RANK(B1,$B$1:$B$75). This will rank the picture in cell B1 among the list of pictures in column B.
Copy and paste the formula to cells C2 to C75. This will rank all the pictures in column B.
Select cell D1 and enter the following formula: =IF(MOD(C1,15)=0,15,MOD(C1,15)). This will assign a column number for each picture based on its rank, from 1 to 15.
Copy and paste the formula to cells D2 to D75. This will assign column numbers for all the pictures in column B.
Select cell E1 and enter the following formula: =QUOTIENT(C1-1,15)+1. This will assign a row number for each picture based on its rank, from 1 to 5.
Copy and paste the formula to cells E2 to E75. This will assign row numbers for all the pictures in column B.
Select cell F1 and enter the following formula: =OFFSET($G$1,(E1-1)*5,D1-1). This will reference the cell in the bingo card that corresponds to each picture's row and column.
Copy and paste the formula to cells F2 to F75. This will reference all the cells in the bingo card for all the pictures in column B.
Select cell G6 and enter "BINGO" horizontally, one letter per cell.
Select cell G7 and enter "FREE" in bold. This will be the free square in the center of the bingo card.
Select cell G8 and enter "Card #".
Select cell H8 and enter 1. This will be the card number for this bingo card.
Select cell G9 and enter "Name".
Select cell H9 and enter your name or leave it blank. This will be the name of the player for this bingo card.
Select cell G10 and enter "Drawn".
Select cell H10 and enter "No". This will indicate whether this card has been drawn or not.
Select cells H6 to L10 and press Ctrl+Shift+F to open the Format Cells dialog box.
Go to the Alignment tab and select Center from both Horizontal and Vertical lists. Click OK. This will center-align these cells.
Select cells H7 to L7 and press Ctrl+B to make them bold. This will highlight these cells as column headers for the bingo card.
Select cells H11 to L15 and press Ctrl+V to paste the values from column F. This will fill the bingo card with the random pictures from column B.
Select cells H11 to L15 and press Ctrl+Shift+F to open the Format Cells dialog box.
Go to the Border tab and select a thin line for all the borders. Click OK. This will create a grid for the bingo card.
Select cells G6 to L15 and press Ctrl+1 to open the Format Cells dialog box.
Go to the Font tab and select a font size of 14. Click OK. This will make the bingo card more readable.
Select cells G6 to L15 and adjust the column width and row height as needed. You can also merge and center cells G6 to L6 and G8 to G10.
Select cells G6 to L15 and press Ctrl+C to copy them.
Select cell N6 and press Ctrl+V to paste them. This will create a copy of the bingo card.
Select cell O8 and change the card number from 1 to 2. This will be the second bingo card.
Repeat steps 21 to 30 as many times as you need to create more bingo cards. You can change the card numbers accordingly.
How to Format and Print the Bingo Cards in Excel
Once you have created your bingo cards in Excel, you can format them according to your preferences. You can change the font, color, size, alignment, border, etc. of the cells. You can also add some background or images to make them more attractive. Here are some steps you can follow:
Select all the bingo cards that you want to print by holding down Ctrl and clicking on each one.
Go to the Page Layout tab and click on Print Area. Select Set Print Area from the drop-down menu. This will define the area that will be printed on each page.
Go to the Page Layout tab and click on Margins. Select Narrow from the drop-down menu. This will reduce the margins around the bingo cards.
Go to the Page Layout tab and click on Orientation. Select Landscape from the drop-down menu. This will rotate the page horizontally, which is better for printing bingo cards.
Go to the Page Layout tab and click on Size. Select Letter from the drop-down menu. This will set the paper size to 8.5 x 11 inches, which is standard for most printers.
Go to the File tab and click on Print. You can preview how your bingo cards will look on paper, and adjust any settings if needed.
Click on Print to print your bingo cards. You can choose how many copies you want, which printer you want to use, etc.
How to Play Bingo in Excel
Now that you have your bingo cards ready, you can use Excel to play bingo with your friends or family. You can use Excel to call out the numbers or pictures for the game, mark off the cards, and keep track of the game progress and winners. Here are some steps you can follow:
How to use Excel to call out the numbers or pictures for the game
If you downloaded or created a bingo template that has a Next button, such as , you can use it to call out the numbers or pictures for the game. You can also use it to clear the card for the next game. Here are some steps you can follow:
Open the bingo template in Excel and enable macros if prompted.
Click on the Next button to randomly select the next number or picture from the remaining ones that haven't been drawn yet.
Announce the number or picture to the players and ask them to mark it on their cards if they have it.
The number or picture that has been drawn will appear in a darker shade on the bingo card. You can also see the list of drawn numbers or pictures on the right side of the template.
Repeat steps 2 to 4 until someone gets a bingo, which is a complete row, column, or diagonal on their card.
When someone gets a bingo, ask them to shout "Bingo!" and show their card to verify their win.
If you want to play another game, click on the Clear button to reset the bingo card and the list of drawn numbers or pictures.
If you created your own bingo cards in Excel without a Next button, you can use another method to call out the numbers or pictures for the game. Here are some steps you can follow:
Create a new worksheet and name it "Caller".
Enter the following formula in cell A1: =RANDBETWEEN(1,75). This will generate a random number between 1 and 75.
Copy and paste the formula to cells A2 to A75. This will create a list of 75 random numbers.
Select the range A1:A75 and press Ctrl+C to copy it.
Select cell B1 and press Ctrl+Alt+V to paste the values only. This will remove the formulas and keep the numbers.
Select the range B1:B75 and press Ctrl+H to open the Find and Replace dialog box.
In the Find what box, enter 0. In the Replace with box, enter 1. Click Replace All. This will replace any zeros with ones, since bingo cards do not have zero as a number.
Select cell C1 and enter 1. This will be the index for the next number to be drawn.
Select cell D1 and enter the following formula: =INDEX($B$1:$B$75,C1). This will display the number in column B that corresponds to the index in cell C1.
Select cell E1 and enter "Drawn".
Select cell F1 and enter "No". This will indicate whether this number has been drawn or not.
Select cells D1:F1 and press Ctrl+Shift+F to open the Format Cells dialog box.
Go to the Alignment tab and select Center from both Horizontal and Vertical lists. Click OK. This will center-align these cells.
Select cell D1 and press Ctrl+B to make it bold. This will highlight this cell as the current number to be drawn.
To call out the next number for the game, select cell C1 and press F2 to edit it.
Enter the following formula: =C1+1. This will increase the index by one.
Press Enter to confirm the formula. This will display the next number in cell D1.
Announce the number to the players and ask them to mark it on their cards if they have it.
Select cell F1 and change it from "No" to "Yes". This will indicate that this number has been drawn.
Repeat steps 22 to 26 until someone gets a bingo, which is a complete row, column, or diagonal on their card.
When someone gets a bingo, ask them to shout "Bingo!" and show their card to verify their win.
If you want to play another game, select the range B1:B75 and press F9 to generate a new set of random numbers. Then, select cell C1 and enter 1. This will reset the index and the current number. Also, select cell F1 and change it from "Yes" to "No". This will indicate that this number has not been drawn yet.
How to use conditional formatting and data validation to mark off the bingo cards in Excel
If you want to mark off the numbers or pictures on your bingo cards in Excel, you can use conditional formatting and data validation to make it easier. Here are some steps you can follow:
Select all the bingo cards that you want to mark off by holding down Ctrl and clicking on each one.
Go to the Home tab and click on Conditional Formatting. Select New Rule from the drop-down menu.
In the New Formatting Rule dialog box, select Use a formula to determine which cells to format from the Rule Type list.
In the Format values where this formula is true box, enter the following formula: =COUNTIF($Caller.$D$1,H11)>0. This will check if the number or picture in cell H11 matches the current number or picture in cell D1 on the Caller worksheet.
Click on Format to open the Format Cells dialog box.
Go to the Fill tab and select a color of your choice. Click OK. This will fill the cell with that color if it matches the current number or picture.
Click OK to close the New Formatting Rule dialog box.
Select all the bingo cards again by holding down Ctrl and clicking on each one.
Go to the Data tab and click on Data Validation. Select Data Validation from the drop-down menu.
In the Data Validation dialog box, select List from the Allow list.
In the Source box, enter Yes,No. This will create a drop-down list with these two options for each cell.
Click OK to close the Data Validation dialog box.
To mark off the numbers or pictures on your bingo cards in Excel, you can either use the drop-down list or the fill color. Here are some steps you can follow:
If you want to use the drop-down list, click on the cell that matches the current number or picture and select Yes from the list. This will indicate that this cell has been marked off.
If you want to use the fill color, click on the cell that matches the current number or picture and press Ctrl+1 to open the Format Cells dialog box.
Go to the Fill tab and select the same color that you used for conditional formatting. Click OK. This will fill the cell with that color and indicate that it has been marked off.
Repeat steps 39 to 42 for each cell that matches the current number or picture.
How to use Excel to keep track of the game progress and winners
If you want to keep track of the game progress and winners in Excel, you can use formulas and functions to count the number of drawn numbers or pictures, check for bingo patterns on the cards, and display the winner's name and card number. Here are some steps you can follow:
Create a new worksheet and name it "Tracker".
Enter "Drawn Numbers" in cell A1 and "Drawn Pictures" in cell B1.
Enter the following formula in cell A2: =COUNTIF($Caller.$F$1,"Yes"). This will count the number of numbers that have been drawn so far.
Enter the following formula in cell B2: =COUNTIF($Caller.$F$1,"Yes"). This will count the number of pictures that have been drawn so far.
Select cells A2:B2 and press Ctrl+Shift+F to open the Format Cells dialog box.
Go to the Alignment tab and select Center from both Horizontal and Vertical lists. Click OK. This will center-align these cells.
Select cells A1:B2 and press Ctrl+B to make them bold. This will highlight these cells as headers for the tracker.
Enter "Card #" in cell D1, "Name" in cell E1, "Bingo" in cell F1, and "Pattern" in cell G1.
Enter 1 in cell D2, your name or blank in cell E2, and the following formula in cell F2: =IF(OR(H2="Row",H2="Column",H2="Diagonal"),"Yes","No"). This will check if the card number 1 has a bingo or not based on the pattern in cell H2.
Enter the following formula in cell G2: =IF(COUNTIF($H$11:$L$15,"Yes")=5,"Row",IF(COUNTIF($H$11:$H$15,"Yes")=5,"Column",IF(AND(H11="Yes",I12="Yes",J13="Yes",K14="Yes",L15="Yes"),"Diagonal",IF(AND(H15="Yes",I14="Yes",J13="Yes",K12="Yes",L11="Yes"),"Diagonal","None")))). This will check if the card number 1 has a complete row, column, or diagonal of marked cells or not.
Select cells D2:G2 and press Ctrl+C to copy them.
Select cell D3 and press Ctrl+V to paste them. This will create a copy of the tracker for card number 2.
Select cell D3 and change it from 1 to 2. This will be the card number for this tracker.
Select cell H2 and press Ctrl+C to copy it.
Select cell H3 and press Ctrl+V to paste it. This will reference the pattern for card number 2.
Repeat steps 11 to 15 as many times as you need to create trackers for more cards. You can change the card numbers accordingly.
Select cells D1:G1 and press Ctrl+Shift+F to open the Format Cells dialog box.
Go to the Alignment tab and select Center from both Horizontal and Vertical lists. Click OK. This will center-align these cells.
Select cells D1:G1 and press Ctrl+B to make them bold. This will highlight these cells as headers for the tracker.
Select cell H1 and enter "Winner".
Select cell H2 and enter the following formula: =IF(F2="Yes",E2&" ("&D2&")",""). This will display the name and card number of the winner for card number 1, if there is one.
Select cell H3 and enter the following formula: =IF(F3="Yes",E3&" ("&D3&")",""). This will display the name and card number of the winner for card number 2, if there is one.
Repeat step 6 as many times as you need to display the winners for more cards. You can change the card numbers accordingly.
Select cell H2 and press Ctrl+C to copy it.
Select cell I2 and press Ctrl+V to paste it. This will create a copy of the winner for card number 1.
Select cell I2 and press Ctrl+Shift+F to open the Format Cells dialog box.
Go to the Alignment tab and select Right from the Horizontal list. Click OK. This will right-align this cell.
Select cell I2 and press Ctrl+1 to open the Format Cells dialog box.
Go to the Font tab and select a color of your choice. Click OK. This will change the color of this cell.
Repeat steps 9 to 13 as many times as you need to create copies of the winners for more cards. You can change the card numbers accordingly.
Conclusion
In this article, we have shown you how to download and print bingo cards in Excel, as well as how to play bingo in Excel. You can use Excel to create and customize your own bingo cards with numbers or pictures, or download free and ready-to-print bingo card templates online. You can also use Excel to call out the numbers or pictures for the game, mark off the cards, and keep track of the game progress and winners. We hope you have enjoyed this article and learned something new. Have fun playing bingo in Excel!
FAQs
Here are some frequently asked questions about bingo in Excel:
How many bingo cards can I print in Excel?
You can print as many bingo cards as you want in Excel, depending on your printer settings and paper size. You can also adjust the margins, orientation, and scaling options to fit more cards on each page.
How can I change the theme or design of my bingo cards in Excel?
You can change the theme or design of your bingo cards in Excel by using different fonts, colors, backgrounds, images, etc. You can also use conditional formatting to apply different formats based on certain criteria, such as matching numbers or pictures.
How can I make my bingo cards more interactive in Excel?
You can make your bingo cards more interactive in Excel by using macros, buttons, checkboxes, etc. You can also use data validation to create drop-down lists or input messages for each cell. You can also use hyperlinks to link your bingo cards to other worksheets or websites.
How can I share my bingo cards with others in Excel?
You can share your bingo cards with others in Excel by saving them as PDF files or printing them out. You can also email them or upload them to online platforms, such as Google Drive or Dropbox. You can also use online tools, such as , to create and share your bingo cards online.
How can I learn more about bingo in Excel?
You can learn more about bingo in Excel by reading online articles, watching YouTube videos, taking online courses, etc. You can also join online forums or communities, such as , where you can ask questions, share tips, or get feedback from other Excel users.
44f88ac181
Comments