Spreadsheets for fun, not profit Chris Herdt 2/22 '26

Matt Lichtenwalner's post on Random Stuff in Google Sheets inspired me to do a little tinkering with random stuff in Google Sheets as well. I now have a moderately good bingo card generator:

People frequently ask me for ways they can modify the HTML+Javascript+CSS version at osric.com/bingo-card-generator/, but I suspect they aren't up for that level of manipulation. On the other hand, loads of people are spreadsheet wizards!

MORE
3d 3 Comments
I also really like your simple check box for generating a new card. I've just been using a blank cell and hitting the delete key, but if your audience doesn't already know that works, a check box is kinda perfect!
Matt Lichtenwalner
I had no idea that any change to any cell of any sheet would update all the RAND() values, but a checkbox/toggle works. I think a button or link would be even better, but I haven't figured that out yet!
Chris Herdt
I found a way to do it a while back. It involved a whole script (I just copied / pasted it from somewhere online).

It worked for a while, but then it broke without me changing anything. I assume that means that the scripting changed. At that point I decided that it felt like too much of a hassle, so I switched to just “delete in an empty cell”
Matt Lichtenwalner