Bingo Cards 75 Numbers
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.
Bingo Cards 75 Numbers
Numbers 1-75 Bingo Cards The classic bingo cards have a 5x5 bingo board with the numbers 1-75. Each group of numbers is assigned to a specific column; B-1-15, I-16-30, N-31-45, G-46-60, O-61-75. Easily create your own classic bingo cards with your home computer and printer using The Bingo Maker. For people with limited vision, print the large format model. The card models available on this site are made for paper size: Letter 8.5 “by 11” (215.9 mm x 279.4 mm). The following cards contain the numbers from 1 to 75. Print 15 bingo cards per page. Bingo cards, numbers from 1 to 75.
Make Lists of Random Numbers
Nov 17, 2020 In standard Bingo, there are 75 different letter-number combinations. Each letter-number combination corresponds with a square on the scorecards. For example, all of the numbers in the 'B' column on the scorecard correspond with 'B' letter-number combinations. More than 500 cards. If you're planning a big game you can get as many bingo cards as you need. Start by ordering 500 bingo cards. After that you can easily add more bingo cards - watch a demo. You can add 100, 250 or 500 bingo cards at a time. A discount of 20% is automatically applied when you add more cards.
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.
When you press the F9 key, the sheet recalculates, and those random numbers change.
Add Random Numbers On Cards
On the three bingo cards, an INDEX/MATCH formula pulls the numbers from the random number tables.You can read more about the INDEX and MATCH functions on my website.
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))
The same number might appear on all three cards, but each card uses a separate lookup table of random numbers. With all that randomness (is that a word?), the 3 cards should never be exactly the same.
Print the Bingo Cards in Excel
The cards are formatted to print three per sheet, on letter sized paper.
After you print each set of three cards, press the F9 key to generate a new set of numbered cards.
Printable Bingo Numbers 1 75
Download the Sample File
Bingo Cards To 75
- 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.
- There is a new Bingo Cards With Pictures sample file for you to download. Go to the Excel Sample files page on my website. On that page, go to the Functions section, and look for FN0045 - Excel Bingo Card With Pictures
- [Update] This is a new Bingo Card Creator file that uses numbers 1 to 100. Go to the Excel Sample files page on my website, and in the Functions section, look for FN0068 - Bingo Card 1 to 100
_____________________