How to Make Bingo Cards in Excel

Written by tricia goss Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
  • Introduction

    How to Make Bingo Cards in Excel

    Bingo can be a fun game played to pass the time. You can play bingo for prizes at a company picnic or a church potluck. Another great use for bingo is to use it as a learning tool in the classroom. Instead of numbers in the columns, you can enter words, element abbreviations or any other symbols your students are learning about.

    (Tricia Goss)

  • 1 / 7

    Open a new, blank Excel worksheet. Select cells "A1" through "E6." Use your mouse by clicking on the first cell and dragging down and across while holding the mouse button, or use your keyboard by clicking inside the first cell, holding down the "Shift" key and using the arrow keys on your keyboard.

  • 2 / 7

    Click the "Border" drop-down, which is on the "Formatting" toolbar in Excel 2003 or earlier and on the "Home" tab of the ribbon in the "Font" group in Excel 2007. Click the "All Borders" option to apply borders to all of your selected cells.

  • 3 / 7

    Keep the cells selected and change the height and width of the cells. In Excel 2003 or earlier, go to the "Format" menu, point to "Row" and choose "Height." In Excel 2007, go to the "Format" drop-down from the "Home" tab and select "Row Height." Enter "90" for the height and click "OK." Go back and select "Column Width," enter the number "15" and click "OK."

  • 4 / 7

    Center the cell selection on your spreadsheet. In Excel 2003 or earlier, click "File" and go to "Page Setup," and then click the "Margins" tab. In Excel 2007, go to the "Page Layout" tab of the ribbon, click on "Margins" and choose "Custom Margins." Select "Center on Page Horizontally" and "Center on Page Vertically," and then click "OK."

  • 5 / 7

    Click on cell "4C." Go to the "Insert" menu in Excel 2003 or earlier, point to "Picture" and select "AutoShape." In Excel 2007, go to the "Insert" tab and select "Shapes." Choose a shape for the "Free" space and insert it into cell "4C." Right-click the shape and choose "Add Text," then type the word "Free." Right-click again and choose "Format AutoShape." Add colour to the shape on the "Colors and Lines" tab, and go to the "Font" tab to change the font, if desired.

  • 6 / 7

    Select cells "A1" through "E1." Right-click and choose "Format Cells." Go to the "Font" tab and choose a large, bold font size and colour, such as "Arial Rounded Bold," size "24" in red. Go to the "Alignment" tab and select "Center" in both the "Horizontal" and "Vertical" dropdowns. Click "OK." Enter an upper case "B" into cell "A1," "I" into "B1" and so on, entering the word "BINGO."

  • 7 / 7

    Save the bingo card template. When you are ready to use it, enter the numbers, letters, words or symbols you want to use in random order, making each card unique. Print them out on cardstock or heavy paper.

  • Checklist

    Things you will need

    • Printer
    • Card stock or heavy paper
  • More information

    Tips and warnings

    In standard bingo, the "B" column contains the numbers 1-15; the "I" column has 16-30; the "N" column has 31-45; the "G" column is 46-60 and the "O" column contains 61-75. A number or cannot appear twice on any card.


Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.