how to make your own bingo cards on excel

How to Create Custom Bingo Cards in Excel

By Thomas King
AD

Ever wanted to create custom bingo cards for a fun party game or an educational activity? Microsoft Excel, with its user-friendly interface and robust features, allows you to design bingo cards quickly and efficiently. Here's a step-by-step guide to help you make your own bingo cards on Excel.

Before you begin, ensure you have Microsoft Excel installed on your computer. For this guide, we'll use Excel 2016, but the process is similar in other versions as well. Let's dive right in!

Setting Up Your Workspace

The first step is to set up your Excel workbook for creating bingo cards. Open a new workbook and save it as 'Bingo Cards' in a convenient location on your computer.

AD
Make Bingo Cards with Words in Excel (+ video tutorial)
Make Bingo Cards with Words in Excel (+ video tutorial)
How to Make Bingo Cards in Excel | Techwalla
How to Make Bingo Cards in Excel | Techwalla
How to Create a Bingo Board Using Excel / Make Bingo Game in Excel Tutorial
How to Create a Bingo Board Using Excel / Make Bingo Game in Excel Tutorial

Decide on the size of your bingo cards. The most common sizes are 5x5 and 4x4. For this guide, we'll create 5x5 bingo cards. To do this, select cells A1 to E5. This will be the first bingo card. You can then easily copy and paste this to create additional cards.

Creating a List of Items for Bingo Cards

In a new worksheet, create a list of items that will appear on your bingo cards. These could be words, numbers, or any other data depending on your theme. For example, if you're creating game-themed bingo cards, your list might include items like "Pikachu", "King of Hearts", "7", "Spring", etc.

How to Create Bingo Game Cards in Excel
How to Create Bingo Game Cards in Excel
Bingo Card Generator - Microsoft Excel
Bingo Card Generator - Microsoft Excel
Free Printable and Virtual Bingo Cards
Free Printable and Virtual Bingo Cards

To ensure a fair game, use the 'Remove Duplicates' feature to avoid repetition. Select your list of items, go to the 'Home' tab, click on 'Remove Duplicates' in the 'Editing' group, and confirm the dialog box that appears. This will remove any duplicate entries from your list.

Randomizing the List of Items

Once you've removed duplicates, you'll want to randomize your list to ensure variety in each bingo card. Select your list of items and go to the 'Data' tab. Click on 'Sort & Filter' in the 'Sort & Filter' group, then click on 'Shuffle'. Your list will now be randomized, ensuring a fair game with varied bingo cards.

AD

Now that your list is ready, let's start filling your bingo cards with these items.

Master Canva & Learn to Design Professional Bingo Cards | Beginner Course
Master Canva & Learn to Design Professional Bingo Cards | Beginner Course
Make FREE Custom Bingo Games in Minutes! | Bingo Cards in Canva Tutorial
Make FREE Custom Bingo Games in Minutes! | Bingo Cards in Canva Tutorial
the cover of my bingo maker customizable printable easy
the cover of my bingo maker customizable printable easy
the ultimate guide to make your own bingo game
the ultimate guide to make your own bingo game
Create Your Own Bingo Cards: Free Printable Templates
Create Your Own Bingo Cards: Free Printable Templates
Create Your Own Bingo Cards
Create Your Own Bingo Cards

Filling the Bingo Cards

Return to the worksheet where you set up your 5x5 grid. Starting with the top-left cell (A1), enter the first item from your randomized list. For the next cell (B1), enter the second item, and so on until you've filled the first row.

Once you've filled the first row, select the whole row (A1:E1) and copy it. Then, select the range A2:E2 and paste. This will paste the copied row into this new range, filling the second row with the next five items from your list. Repeat this process for the remaining rows until your first bingo card is complete.

AD

Creating Additional Bingo Cards

Now that your first bingo card is complete, you can create additional cards by copying and pasting. Select the 5x5 grid (A1:E5), and copy it. Then, starting from cell F1, paste the copied range. Continue this process to create as many bingo cards as you need.

20 Game Editable Bingo Patterns, Create Your Own 20 Game Program Flyer Using My Excel Worksheet Template, Windows PC with Excel Required
20 Game Editable Bingo Patterns, Create Your Own 20 Game Program Flyer Using My Excel Worksheet Template, Windows PC with Excel Required

To print your bingo cards, select all the ranges you've created, go to the 'File' tab, click 'Print', and choose your preferred settings. You can now enjoy your custom-made bingo cards with family, friends, or students!

Creating bingo cards on Excel is not only fun but also a rewarding experience. It teaches you how to use Excel's functionalities effectively, and the final product is a tangible, enjoyable result. Try out different themes and sizes to make your bingo card creations even more exciting. Happy gaming!

AD
AD