Something Totally Different: Excel Tricks to Build Mini Games and Puzzles

 

Although Excel is a professional tool for calculation and data analysis, it can be used for fun too. With a bit of creativity, you can turn a worksheet into a playful space full of tiny games and puzzles. By combining formulas and conditional formatting, you can transform a spreadsheet into an entertaining experience.

In this tutorial, we will show Excel tricks to build mini games and puzzles — something totally different.

Game 1: Number Guessing With Color Hints

This is a number-guessing game where Excel picks a random number and you try to guess it. Excel secretly chooses a number; the player keeps guessing, and Excel tells them if the guess is too high or too low. Conditional formatting gives visual clues with colors.

Set Up Your Playing Field:

Create a clean layout with cells for:

• The secret number (which we’ll hide)
• Your guess input
• Feedback messages

Generate the Secret Number:

• Select cell C2 and enter the following formula:

=RANDBETWEEN(1,100)

This is the number Excel chooses. Later, you can hide this cell if you want.

Create the Input and Feedback System:

• In cell C4, enter your guesses.
• In cell C6, enter the following formula:

=IF(C4="", "Type a guess", IF(C4=C2, "Correct!", IF(C4<C2, "Too low", "Too high")))

Now, when a player types a number in C4, the hint cell tells them what’s going on.

Data Validation (Limit Guesses to Valid Numbers):

• Select cell C4.
• Go to the Data tab >> choose Data Validation.
• Allow Whole number, between 1 and 100.
• Add an input message: “Guess a number between 1 and 100.”

Conditional Formatting for Visual Hints:

You can color the guess cell based on how close it is to the secret number. Create these rules for cell C4 (in this order so the most specific rule wins):

• Select cell C4.
• Go to the Home tab >> select Conditional Formatting >> select New Rule.
• Select Use a formula to determine which cells to format.
• Correct guess (green):

=AND(C4<>"",C4=$C$2)

• “Very close” (yellow), for example, within ±3:

=AND(C4<>"",ABS(C4-$C$2)<=3,C4<>$C$2)

• “Far” (red):

=AND(C4<>"",ABS(C4-$C$2)>3)

Now you have a simple, replayable number-guessing game. Recalculate (F9) to generate a new secret number.

Game 2: Rock–Paper–Scissors vs. Excel

You can build a Rock–Paper–Scissors game in Excel. It’s an interesting mini game: you pick Rock, Paper, or Scissors from a dropdown, Excel randomly chooses its own move, and then it declares the winner.

Set Up the Choices:

• List the options:
  • Rock
  • Paper
  • Scissors
• Your Choice
• Excel’s Choice

Add a Dropdown for Choices:

• Select D2.
• Go to the Data tab >> choose Data Validation.
• Allow List and set Source to:

=$A$2:$A$4

Excel’s Random Choice:

• In cell D4, enter the following formula:

=INDEX($A$2:$A$4,RANDBETWEEN(1,3))

Each time the sheet recalculates, Excel picks one of the three options.

Decide the Winner:

• In cell C6, type: Result.
• In cell D6, enter this formula:

=IF(D2="","Choose Rock, Paper, or Scissors",
IF(LOWER(D2)=LOWER(D4),"It's a tie!",
IF(OR(
AND(LOWER(D2)="rock",LOWER(D4)="scissors"),
AND(LOWER(D2)="paper",LOWER(D4)="rock"),
AND(LOWER(D2)="scissors",LOWER(D4)="paper")
),"You win!","Excel wins!")))

Choose an option from the dropdown in cell D2. Press Shift+F9 to let Excel pick again and see who wins.

Optional: Scoreboard

If you want to track the score, you can add two manual counters:

• G2: “Your Score” and H2: type 0 to start.
• G3: “Excel Score” and H3: type 0 to start.

Increase these scores manually when someone wins. For a more advanced version, you could use macros to automate this, but for a pure-formula game, manual scoring keeps things simple.

Game 3: Tic-Tac-Toe With Conditional Formatting

You can create a tiny Tic-Tac-Toe puzzle board in a 3×3 grid. Two people can play by typing X and O. Excel will detect the winner.

Build the Board:

• In cells B2:D4, create a 3×3 grid.
• Add borders to make it look like a board.
• Make the cells larger:
  • Change row height and column width to create a square.
  • A simple rule of thumb is:

Row Height ≈ Column Width × 5

• This ratio often produces visually square cells on many displays.

Add Dropdown (Restrict Entries to X or O):

• Select range B2:D4.
• Go to the Data tab >> select Data Validation.
• In Allow: select List.
• Source:

X,O

Now players can only choose X or O (or leave blank).

Detect a Winner:

Add helper cells to check each line. You can keep these off to one side, say in columns F and G.

• In F2 type “X Wins?”, and enter the following formula:

=OR(
AND(B2="X",C2="X",D2="X"),
AND(B3="X",C3="X",D3="X"),
AND(B4="X",C4="X",D4="X"),
AND(B2="X",B3="X",B4="X"),
AND(C2="X",C3="X",C4="X"),
AND(D2="X",D3="X",D4="X"),
AND(B2="X",C3="X",D4="X"),
AND(D2="X",C3="X",B4="X"))

• In F3 type “O Wins?”, and in G3 enter the same formula replacing “X” with “O”.

=OR(
AND(B2="O",C2="O",D2="O"),
AND(B3="O",C3="O",D3="O"),
AND(B4="O",C4="O",D4="O"),
AND(B2="O",B3="O",B4="O"),
AND(C2="O",C3="O",C4="O"),
AND(D2="O",D3="O",D4="O"),
AND(B2="O",C3="O",D4="O"),
AND(D2="O",C3="O",B4="O"))

Now show the status to players in a friendly message:

• In F4 type: Game Status.
• In G4, enter the following formula:

=IF(G2,"X wins!",
IF(G3,"O wins!",IF(COUNTBLANK(B2:D4)=0,"It's a draw","Game in progress...")
))

Highlight the Board When Someone Wins:

Use conditional formatting on the board to change color when there is a winner.

• Select B2:D4.
• Go to the Home tab >> select Conditional Formatting >> select New Rule.
• Select Use a formula to determine which cells to format.
• For X winning: Set a light blue fill with this rule.

=$G$2=TRUE

• Another rule for O winning: Set a light green fill.

=$G$3=TRUE

When X or O has three in a row, the whole board will change color, and the status cell will announce the winner.

To reset the game, clear the cells B2:D4 on the board.

Game 4: Random Word Scramble Puzzle

Let’s build a simple word puzzle. Excel will pick a word from a list and scramble its letters. The player tries to guess the original word.

Layout:

• Create a word list. You can choose any words you like.
• Secret Word
• Scrambled Letters
• Your Guess
• Feedback

Pick a Random Secret Word:

• In cell D2, enter the following formula:

=INDEX($A$2:$A$11,RANDBETWEEN(1,COUNTA($A$2:$A$11)))

This cell returns a word from the list. You will scramble this word. Hide the column later if needed.

Split the Word Into Letters (Dynamic Array Approach):

• In cell C5, enter the following formula:

=TRANSPOSE(MID(D2, SEQUENCE(LEN(D2)), 1))

This spills each letter into its own cell across the row.

Randomly reorder the letters using SORTBY and RANDARRAY:

• In C7, enter the following formula:

=SORTBY(C5#,RANDARRAY(,COLUMNS(C5#)))

This outputs the scrambled letters in row 7—now you have a jumbled version of the secret word.

If you want them in one cell for the player to see, use:

• Label B9 as Puzzle, and show C9 as the scrambled word.
• In C9, enter the following formula:

=TEXTJOIN("",TRUE,C7#)

Player Guess and Feedback:

• In C13, enter the following formula:

=IF(C11="","Type your guess",
IF(LOWER(C11)=LOWER(D2),"Correct!","Try again."))

You can add conditional formatting to C11:

• Green fill when correct:

=AND(C11<>"",LOWER(C11)=LOWER($D$2))

Every time you press F9, Excel will pick a new secret word and scramble it again.

Tips to Make Your Games Feel “Real”

If you want these mini games and puzzles to feel more polished, these tips can be useful:

• Hide all helper cells using a white font or by moving them off to the side.
• Lock the sheet and protect formula cells that should not be changed, leaving only the input cells unlocked.
• Insert simple shapes and text boxes as “buttons” with instructions like “Type here to guess” or “Press F9 for a new game.”
• Use borders, header cells, and colors to give each game a simple but clean visual style.

Wrapping Up

You can follow these Excel tricks to build mini games and puzzles. Building games in Excel is more than just entertainment—it’s an excellent way to develop problem-solving skills, master formulas, and explore lightweight user interface design. Start with simple projects like the number-guessing game, then work your way up to more complex creations. Open Excel, start experimenting, and remember: the only limit is your creativity. All of these games rely on core Excel skills, just used in “something totally different” from dashboards and reports.