How to Create Custom Bingo Cards in Excel
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.



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.



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.
Now that your list is ready, let's start filling your bingo cards with these items.






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.
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.

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!




