In the Value or Formula box type in the letter that you have selected (Using my my example above, you would type the letter A ). Select from the drop down menu, Text that Contains. Click Formatįormatting and click on the " Add Another Rule" to Add New Rule. if you click on and select the letter A, hold down the CTRL key and select all of the letter A's ). Pick one letter, hold down the CTRL key and select each of the same letters on your spreadsheet (i.e. If the text is incorrect the letter will appear red. Letters are placed in the cell the cell will turn green and green text willĪppear in the cell. Next step is to add conditional formatting to the cell so that when the correct
#Abcya crossword puzzle maker how to
Using the buttons on the formatting toolbar.Īdding Comments and Formatting How to Video The How to Video demonstrates how to insert oneĬomment but you will add all 15 comments to your puzzle. Place all borders around all your words in the puzzleĬells both vertically and horizontally. State in each cell, recreating the exact crossword puzzle you just printed offĮntering Words in Your Excel Worksheet How to Videoįormatting Your Crossword Puzzle in Google Sheets You want a blank column to appear on both the leftĪnd right side of your crossword as well as a blank row above and below your
New Google Sheets spreadsheet in Google Drive and name it Interactive Crossword Puzzle. Your crossword will be the skeleton of how you will format your actual Interactive Crossword Puzzle. This shouldīe very simple as you already have all of the clues and answers typed out in Word. Puzzle, you will need to actually complete it with a pencil.
0 kommentar(er)
