How to Make Bingo Cards in Excel

1.
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.
Click the 'Border' dropdown, 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.
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' dropdown 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.
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.
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 color to the shape on the 'Colors and Lines' tab, and go to the 'Font' tab to change the font, if desired.
6.
Select cells 'A1' through 'E1.' Right-click and choose 'Format Cells.' Go to the 'Font' tab and choose a large, bold font size and color, 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.
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.