If you find any of this useful, please consider donating via PayPal to help keep this site going.

Email news@statisticool.com to sign up to receive news and updates

Times Table BINGO


With the recent Coronavirus Disease 2019 (COVID-19), many children are at home because schools are closed. Education and fun, however, should not stop. Here is a spreadsheet I created that gets kids working on their times table (up to 12), using the game of BINGO.

When you open the BINGO spreadsheet, you will see four columns of numbers. One column is of random numbers between 0 and 1. Another column is the numbers in the times table, but with duplicates eliminated. For example, in the times table, you can get 24 by 6x4, 4x6, 12x2, 8x3, 3x8, and so on, but the column will just have a single 24. The other two columns are the same thing, but for the second BINGO board.

If you press control-s, it will run a simple Visual Basic macro. It will sort the first times table column by the first list of random numbers, and the other times table column by the other list of random numbers. Each BINGO board then just takes the first 24 times table numbers (remember, randomly sorted), to populate the BINGO boards.

There are many ways one could play this times tables table BINGO game. One way is, the drawer could say 5x3, and the child would need to cover the 15 square if it is on their board. Another way is the opposite, where the child would need to say 3x5 (or 5x3) if the drawer draws a 15, to cover their 15 square.

I set the Print Area, that is, the area that will be printed out when you click Print, to be the area with the grid in the outlined box. This way, you can just open up the spreadsheet and press control-s to run the sorting macro, then print, and you're good to go.

If you find this spreadsheet to practice the times table using BINGO useful, please credit Statisticool.com. Thanks for reading.

Please anonymously VOTE on the content you have just read:


If you enjoyed any of my content, please consider supporting it in a variety of ways:

AFFILIATE LINK DISCLOSURE: Some links included on this page may be affiliate links. If you purchase a product or service with the affiliate link provided I may receive a small commission (at no additional charge to you). Thank you for the support!