![]() This is the cell that turns the blanks from yellow #s to random white letters. Be careful not to delete or overwrite the “1” in cell A43. If you know you aren’t using that much space, just delete the cells you don’t want. Generally, smaller is better, but it’s your word search puzzle, so do it as big as you want. The sheet you downloaded comes 29 wide by 42 long. Adding space is easier- you just copy and paste “empty” cells with the yellow # in them. You can change this later, but once you start, taking space away may be hard if you’ve spread words throughout the space you made and you want to compact it. The bigger the puzzle, the harder it is to find words. A lot of words can be fit into a fairly small area. For example, the Fruit word search is 11 letters wide and 9 long, and fits in 12 words. Estimate how big you want your word search puzzle to be. If you want to look at a simple completed example for comparison, click here to download the Fruit Word Search shown in the slideshow above.Ģ. It’s a fairly old version of Excel, so you shouldn’t have any trouble opening it or have any compatibility issues. ![]() Ready to give it a try? Here’s how step by step:ġ. If the cell has anything else- a zero, a blank, whatever, the formula puts a random letter in every unused cell. If that cell has a “1” in it the unused cells have a yellow # sign in them. The yellow cells have a formula in them that either puts a random letter in them or a yellow # sign, depending on the contents of a single special cell, A43. With the empty spaces in yellow, you can see a lot of the words fairly easily, but when the empty areas fill in, it’s a lot harder! These are two examples each with the same words to be searched, but with the random fill spaces turned off and on.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |