Have some fun with Excel, by playing simple games, or fancy spreadsheet versions of classic games like Monopoly, Battleship, bingo, and much more.
Author: Debra Dalgleish
Print Bingo Cards in Excel
In my Bingo Card template, there are three cards on the main worksheet, which is named Cards. Each bingo card has a set of 24 random numbers, with a FREE square in the centre of the card.
You can print sets of cards for a social event, or classroom, or as a meeting icebreaker at work. The random numbers are filled in by formulas, so there are no macros needed in this workbook.
And for younger players, there's a version that uses bingo pictures instead of numbers.
Get the Bingo Card Excel file on the Print Bingo Cards page -- there are 4 different downloads for you to choose from.
Hidden Treasures Game
Here's another little Excel game that I created, with children in mind - Treasure Hunt. It's set up in a grid, similar to bingo, but you choose numbers, instead of waiting for the numbers to be called.
The main worksheet has 25 dark green cells, invisibly numbered 1 to 25. Some of the cells have a flower (good) and some have a raindrop (bad).
How to Play Treasure Hunt
In the screen shot below, the Flower Hunt version is showing, but there are 4 themes to choose from - Treasure Hunt, Flower Hunt, Vacation Hunt and Smile Hunt.
To change the theme, click the data validation drop down arrow at the top left of the worksheet, and click on a game name to select it.
On my Contextures blog, there are details on how I built the game, and how it works. There are instructions for changing some parts of the game, such as:
Excel Function Personality Game
If you’ve been anywhere online in the past decade, you’ve probably seen those personality quizzes, such as Which Star Wars Character Are You?
If you've enjoyed those games, there's good news - now you can play a new game – Which Excel Function Are You? This screen shot shows the first question from the quiz, and I'm clicking on a radio button, to select my answer.
To see all the questions, and to take the quiz, get this Excel file in the download section, at the bottom of this page.
After you download the file, you can add more questions, or select different functions, to create your own quiz. Or, use this structure to create a completely different type of quiz!
On my Contextures blog, there are details on how I built the game, and how it works. That might help you get started, if you want to make changes to the workbook
Excel Concentration Game
Working with Excel can require extended periods of concentration. So, by the end of a longday, you might want a change of pace.
How about a game of Concentration in Excel? Doug Glancy, from the YourSumBuddy site, created a version of this classic card game (some people call it the Memory game), and you can can get a copy in the download section at the end of this page.
Here's what Doug says about creating this game:
When the file opens, be sure to enable the macros, so the game will run. There’s one worksheet, with a button that you click to start the game.
Next, the game starts, with a deck of cards, turned face down. You select two cards and try to choose matching pictures. The game records the number of clicks, a timer keeps track of the seconds used, and the match count. I am very bad at this game!
There are game options, including number of players, and type of card.
How It Works
Doug’s concentration game is built on a UserForm. In the sample file you can see all the code that makes it operate.
Note: It took me a couple of minutes to find the sets of cards – one for mammals and one for birds. They’re to the right of the visible area on the UserForm.
Hidden Games in Excel
In the early versions the early versions of some Microsoft products, including Excel, there were hidden features called Easter Eggs.
Microsoft stopped adding Easter Eggs to its products in 2002, and you can see the full list of hidden goodies in this Wikipedia Easter Egg article.
Excel 95 Hall of Tortured Souls
For example, in Excel 95, there was a hidden first-person shooter game, similar to Doom, called "Hall of Tortured Souls". It had different rooms to explore, where you found the names and faces of the program's developers.
You can see a dizzying video of this Easter Egg in this video, on the FlyTech Videos YouTube channel.
In the comments, someone claimed that Easter Eggs were added to increase the program's size:
However, in replying comment, former Excel developer, Ross Comer, said that was incorrect -- the Easter Eggs were only added as a fun feature.
I did a bit of searching, to verify that Ross Comer was really on the Excel team, and there are 5 Excel patents granted, with his name as an inventor, from 1998 to 2006. So, it seems legitimate!
And this 2011 Microsoft Bing blog post says Ross owned the AutoCorrect and AutoComplete features in Excel 5:
Excel 97 Flight Simulator
In the next version, Excel 97, there was the most famous Excel Easter Egg, the flight simulator. This screen shot shows the names of some Charting Testers on the Excel 97 development team.
You can see a choppy recording of that built-in game in this YouTube video, on the Tom.K YouTube channel.
Excel 2000 Dev Hunter
The last hidden game was in Excel 2000, and it was called Dev Hunter, similar to the arcade game, Spy Hunter. Running that game was more complicated than the previous Excel Easter Eggs. You needed to install Web Components to run that game, and go to cell WC2000 on the Excel sheet, to get the game started.
You used the keyboard to steer your car down a road, while shooting, spilling oil, and turning the car lights on and off. And if you hear the boss headed toward your desk, press Esc, to quit the game. Fun!
You can see a short clip of Dev Hunger in this short video, on the RicoElectrico YouTube channel.
More Excel Games
Here are a few more Excel games that you can check out.
Civilization Game in Excel
On YouTube, s0lly posted a trailer for a game that he created in Excel. It’s based on the old game, Civilization, and this version is called [Cell]ivization.
Wouldn’t you love to have a catapult or two in some of your spreadsheets?
Take a look at some of s0lly’s other Excel videos too, on his YouTube channel.
S0lly says that the game is “very light on features (basically just build units and attack the opposition)”, but S0llyplans to add more features, if people are interested.
I found two versions of an Excel Monopoly game, created by Andrew Werner.
Andrew Engwirda has several Excel games on his site, including Battleship and a Word Search puzzle.
Excel Hangman Game
Have fun with this word guessing game - Hangman by Dick Kusleika
Blackjack Card Game
Ken Puls created a Blackjack game in Excel, that you can download from his site.
Andy Pope Excel Games
Next, see the games that Andy Pope has on his website. There’s a Suduko game, Mastermind, and several others.
For example, here's a screen shot of Andy's Excel-based Jawbreak game. The game is built on a UserForm, with a button on the worksheet to start the game.
The object is to clear all the balls from the screen, by selecting and deleting matching balls. Remaining balls drop down to fill in the gaps, and when you clean an entire column, the other columns will shift left.
I enjoyed the game, which is simple to play, but takes a bit of thinking to plan your moves. It keeps a list of high scores, so you can try to beat your previous best high score.
You can download the Excel Jawbreak game from Andy’s website. While you’re there, take a few minutes to look at some of the other brilliant things that Andy has done.
Andrew Engwirda Excel Games
Andrew Engwirda has several Excel games on his site too, including Battleship and a Word Search puzzle.
Reddit Spreadsheet Games
There are several Excel games listed in this Excel Wiki on Reddit, including Tetris, Scrabble and CellSweeper.
Space Invaders for Excel
This video, Spreadsheet Invasion, was created by Amy Thornley, frame by frame in Excel, for an online contest, Smile For London.
So, you can't really play this gam -- it's only available to watch. But, if you’re old enough to remember Space Invaders, this might make you smile.
More Excel Game Links
There are links to more Excel games in the following posts on my Contextures Blog:
Concentration Game: Get the memory card game by Doug Clancy, and test your concentration skills! The zipped file is in xlsm format, and contains macros.
Treasure Hunt Game: To enjoy some Excel treasure hunting, you can download the sample file: Excel Treasure Hunt Game. It’s a zipped file, in xlsm format. For the New Game button to work, you’ll have to enable macros. The Hunt sheet is protected, with no password.
Which Excel Function Are You?:- Get this Excel function personality quiz, then answer survey questions with option buttons, to find out which Excel function you are. The zipped file is in xlsx format, and does not contain any macros.
Last updated: December 14, 2022 3:49 PM