Download This Excel Bingo Card Template and Start Playing Today
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
Download File: https://www.google.com/url?q=https%3A%2F%2Ft.co%2FibaoT91PSc&sa=D&sntz=1&usg=AOvVaw3zhELJvyqN_FyWyyF2jnUx
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:
Print Bingo Cards in Excel Games With Numbers or Pictures: 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.
Bingo Template How To Excel: 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.
Free Printable Bingo Cards - Bingo Card Generator: 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 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 Bingo Template How To Excel, 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:
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
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 Ctr