![]() ![]() ![]() Creating an Interactive Crossword in Excel Creating an Interactive Crossword in Excel First you must come up with your clues and your answers. You will include ten words in your puzzle. You will use the 50 states site below to find your 10 clues. Once you have your words and clues figured out, go to puzzle maker to have it format your puzzle for you. Crossword puzzles are excellent mind-flexing activities and serve as effective teaching tools -- and you only need Microsoft Word to create your own. Microsoft Office. Well, you could build crosswords in MS Word but I think Excel might be more suited. I’m assuming you just want to build a puzzle, building an app to ‘play. Follow the directions for creating your crossword. Make sure you include your name in step 1. ![]() ![]() This will distinguish your crossword from the other student's crossword when they are printed out. Copy and paste your clues in Microsoft Word. This will help you when you are filling in your puzzle. Make sure that you use your own words and clues, not the one listed below. Print out your crossword. Enter all you words into your printed out crossword then add them to your excel worksheet. The How to Video below shows two words entered. You will enter all ten of your words. You want a blank column to appear on both the left and right side of your crossword as well as a blank row above and below your crossword. Place all borders around all your words in the puzzle and c enter align text in cells both vertically and horizontally. Place all borders around your text. Do not add borders to any of the blank cells. Select all the cells that contain text then on the Home tab select Borders the All Borders. Vertically and Horizontally align your text in the cells. Select the cells with the text and click the vertical and horizontal alignment buttons on the Home tab. Change the size of the cells. Select all the cells in your worksheet by clicking the box above the number 1 and to the left of the A column. With the Home tab selected click format on the cell section and select Column Width. Set the column width to 5 at the Column Width dialog box. Click again the Format again and select Row Height and set the row height to 20. Add a solid fill to the empty cells that do not contain text. Select the empty cells by holding down the left mouse and dragging over them. Click on the fill paint can and select a color. The fill color will then be applied to the empty cells.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |