How to Make Bingo Cards in Excel (Step by Step)
To make bingo cards in Excel, shape a block of cells into a square grid, type one bingo word into each cell, center the text, and add borders so it looks like a card. If you want shuffled cards, you can use the `RAND` and `INDEX` functions to pull random words from a list. It works, but it's fiddly. For a quick stack of truly unique cards, a free bingo card generator does the shuffling for you in seconds.
Want to skip the formulas? Open the free generator, paste in your word list, choose a grid size, and print. If you'd rather build it in Excel yourself, the full guide is right below.
Excel has one big advantage over most tools: it can do math. That means you can use formulas to randomize words, so in theory each card comes out different. That's something Word can't do on its own.
But Excel also has a learning curve. Squaring up cells, writing formulas, and forcing a fresh shuffle all take a few steps. If you're comfortable in spreadsheets, it's a fun project. If you're not, it can feel like a lot of work for a party game.
So here's the honest version. Excel is great if you love spreadsheets and want full control. If you just need cards fast, there's a simpler path at the end of this guide.
What You'll Need
Keep it simple:
- A list of at least 24 bingo words for a 5x5 grid.
- Any version of Excel, including the free Excel Online in your browser. Google Sheets works almost the same way.
- A printer or PDF export for the finished cards.
No word list yet? Grab the free one further down. Copy and paste it straight in.
How to Make a Bingo Card in Excel: Step by Step
Here's the basic build, from blank sheet to a clean printable card.
Step 1: Make the cells square
Spreadsheet cells are wide rectangles by default. Bingo needs squares. To fix this:
- Select all the columns you'll use (say A through E).
- Right-click a column header and set the width to about 12.
- Select the rows, right-click, and set the row height to about 70.
Play with the numbers until the cells look square on screen. This is the single most important step for a card that looks right.
Step 2: Build the grid
For a classic 5x5 card, you'll use a 5-by-5 block of cells, for example A1 to E5. For little kids, use 3x3. For a faster game, 4x4. That's your bingo grid.
Step 3: Add your words
Click into each cell and type one bingo word. Fill 24 cells for a 5x5 and leave the center cell (C3) for your free space. Type "FREE" there, or leave it blank and shade it.
Step 4: Center the text
Select the grid, then on the Home tab click "Center" for horizontal alignment and "Middle Align" for vertical. Turn on Wrap Text too, so longer words sit neatly inside each square instead of spilling over.
Step 5: Add borders
With the grid selected, open the borders menu on the Home tab and choose "All Borders." Now it actually looks like a bingo card instead of a spreadsheet. Bold the words or shade the free space if you want a little extra style.
Step 6: Print or save
Go to File > Print and set it to fit on one page, or Save As a PDF. Print a single test card first to catch any margin issues before you run a batch.
Shuffling Words With Formulas (the Excel Way)
This is where Excel earns its keep. You can use formulas to pull random words from a list so each card differs. Here's the simple version:
- Paste your word list into a spare column, say column H, one word per row.
- Add a random number next to each word in column I using `=RAND()`.
- Sort by column I to scramble the order, or use `=INDEX($H$1:$H$30, RANDBETWEEN(1,30))` in each grid cell to pull a random word.
- Press F9 to recalculate and get a fresh shuffle for the next card.
It works, but there are gotchas. `RAND` and `RANDBETWEEN` can repeat the same word on one card, so you may see duplicates inside a single grid. Fixing that needs longer formulas with helper columns to filter out repeats. For most people, that's more spreadsheet wrangling than a game night is worth.
Free Bingo Word List (Copy & Paste)
Here's a ready-to-use list of 30 general bingo squares. Pick any 24 for a 5x5 card, or 9 for a 3x3. Paste a column straight into Excel or into the generator.
| Nature | Food & Drink | Hobbies |
|---|---|---|
| Sunflower | Pancakes | Painting |
| Butterfly | Pizza slice | Knitting |
| Acorn | Ice cream | Gardening |
| Pinecone | Lemonade | Photography |
| Seashell | Popcorn | Fishing |
| Raindrop | Cupcake | Hiking |
| Mushroom | Sandwich | Reading |
| Maple leaf | Smoothie | Baking |
| Ladybug | Tacos | Cycling |
| Dandelion | Donut | Pottery |
Mix words across the columns so cards feel varied. For very young kids, choose easy-to-picture words like butterfly, pizza slice, and ladybug.
The Catch With Excel Bingo Cards
Even with formulas, Excel has limits for bingo:
- Duplicate squares. Basic random formulas can repeat a word on the same card unless you build extra logic to stop it.
- Manual re-shuffling. You press F9, then print, then F9 again for the next card. For 25 players, that's 25 reshuffles and 25 print jobs.
- Layout drift. It's easy to accidentally nudge a column width and throw off the whole grid.
None of this is a dealbreaker if you enjoy spreadsheets. But if you just want a printed stack of cards without babysitting formulas, there's an easier way.
A Faster Way: Use a Generator
A free bingo card generator skips all the formula work. You:
- Paste your word list once.
- Pick a grid size (3x3, 4x4, or 5x5).
- Choose how many cards you need.
- Print. Every card is unique, with no repeated squares inside a single grid.
It handles the randomizing and the no-duplicates rule for you, so you get a clean printable set in a couple of clicks. Plenty of people prototype an idea in Excel, then use the generator to actually produce the cards.
Printing Tips for Sharp Cards
Whichever tool you use, these help:
- Set print area and "fit to one page" so the card doesn't split across sheets.
- Print a test card to check margins before a full run.
- Use cardstock for cards that survive repeated game nights.
- Print in black and white to save ink. Bingo reads fine without color.
- Laminate or use sleeves so players mark with dry-erase markers and you wipe the cards clean.
Bingo Grid Sizes by Age
Match the grid to your players for the smoothest game.
| Age group | Grid size | Tips |
|---|---|---|
| Toddlers (2–4) | 3x3 | Use pictures, not words. Keep it short. |
| Kids (5–9) | 4x4 | Mix simple words and pictures. Small prizes help. |
| Tweens & teens | 5x5 | Add themed or pop-culture squares. |
| Adults | 5x5 | Try blackout rounds for a longer game. |
| Seniors | 4x4 | Larger print, fewer squares, clear fonts. |
Prefer a different tool? You can also build cards in Word, learn how to print bingo cards at home, or see how to guarantee unique, non-duplicate cards for a big crowd.
Frequently Asked Questions
Can I make bingo cards in Excel for free?
Yes. Excel's grid and formulas let you build cards at no cost, and Excel Online is free in any browser. Google Sheets works almost identically. The only downside is that shuffling cards with formulas takes setup, which the free generator handles for you.
How do I make Excel cells square for a bingo card?
Select your columns and set the width to about 12, then select your rows and set the height to about 70. Adjust until the cells look square on screen. Square cells are what make the grid look like a real bingo card.
How do I randomize words in Excel bingo cards?
Put your words in a column, add `=RAND()` beside each one, then sort by that random column to scramble the order. Or use `=INDEX(list, RANDBETWEEN(1, count))` in each cell. Press F9 to reshuffle for the next card, but watch for duplicate words on a single card.
Why are words repeating on my Excel bingo card?
Random formulas like `RANDBETWEEN` can pick the same word twice on one card. Stopping that needs extra helper columns and longer formulas. If you'd rather avoid the headache, a bingo generator blocks duplicates within a card automatically.
Is Excel or a generator better for bingo cards?
Excel is great if you love spreadsheets and want full control. A generator is faster and easier when you need many unique cards without managing formulas or duplicates. Many people design in Excel, then use the generator to print the final set.
Can I save my Excel bingo card as a PDF?
Yes. Go to File > Save As (or Export) and choose PDF. Set the print area and "fit to one page" first so your grid stays intact. A PDF prints the same on any computer, which is handy for copy shops.
Ready to Make Your Bingo Cards?
Excel is a fun way to build cards if you like formulas, but if you just want a stack of unique ones, let the free bingo card generator do the shuffling. Paste your list, pick a grid size, and print as many different cards as you need. No sign-up, no fee, and no duplicate squares, so your game is ready to go.
