Browse » Home
Friday, January 27, 2012
How to Design a Crossword Puzzle With Excel 2003
Designing the Crossword Puzzle
1. Open a new document in Microsoft Excel 2003.
2. Select the area of your spreadsheet where the crossword puzzle will go. (Make sure to keep this same area highlighted throughout all of the steps in this first section.) Then right-click over the selected area and choose 'Format Cells' from the pop-up list.
3. Select the 'Alignment' tab. Then choose 'Right Indent' for the horizontal text alignment and 'Top' for the vertical text alignment.
4. Select the 'Font' tab. Then pick 'Arial' for the font, '10' for the font size and 'Superscript' for the effects and click 'OK.'
5. Select 'Format,' 'Row' and 'Height' from the toolbar. Type '20' into the 'Row Height' dialog box and click 'OK.'
6. Select 'Format,' 'Column' and 'Width' from the toolbar. Type '4' into the 'Column Width' dialog box and click 'OK.' The selected cells should now be square.
7. Select the 'Border' button from the 'Formatting' toolbar. Choose 'All Borders' to create a border around each selected cell.
Adding Content
8. Place your cursor in the cell where you want to add a number. Type in the number you want. Then press 'Enter' or use your arrow keys to move to the another cell in the crossword.
9. Insert additional numbers into the desired cells until they are all in.
10. Select any cells within the crossword puzzle that you want to shade (areas where letters/words will not be entered when printed). To select multiple cells at the same time, hold down the 'ctrl' key on your keyboard as you select each cell.
11. Click on the arrow beside the 'Fill (Color)' button in the 'Formatting' toolbar and choose black. The selected areas will be shaded.
Inserting the Clues
12. Place your cursor outside the crossword puzzle (below it) to insert the clues for the crossword puzzle. Type in 'ACROSS' and bold the text by using the 'Bold' button in the 'Formatting' toolbar. Then press 'Enter.'
13. Type in the number '1' and your first clue for the 'ACROSS' category and press 'Enter.' Continue typing in all of the other clues until you are finished.
14. Next to the Across clues, enter the Down clues in a different column. Type in the word 'DOWN' and bold it. Then press 'Enter.'
15. Type in each number and clue for the 'DOWN' category, pressing 'Enter' after each one. Continue typing in other numbers and clues until they are complete.
16. Save your work by selecting 'File' and 'Save' from the toolbar. Name your crossword puzzle file and click 'Save.'