How Can I Make a List of Words to be Random Instead of Alphabetical
You have a list of words that are sorted alphabetically and you want them to be in random order for a word search. Just follow the steps below.
Your list will look something like this below in alphabetical order inside your .csv file.
Click on cell B1 and enter =rand() like you see below
Press the enter key on your keyboard and a random number will appear (odds are it will not be the same as below, since this formula is creating a random number).
Now click the cell one time. Double click on the little square on the bottom right of the cell. This will fill column B to the same row as Column A has information in it. Or you can left click on the square while holding down left mouse button and drag it down the column.
Next click the triangle at top left of cells to highlight the whole excel sheet.
Click the "Data" on the menu, and then click on the "Sort". Change sort by to Column B, press "OK".
Now your words in column A are randomized.
Now you need to click on column B to hightlight it all, then right click and pick delete.
Now save your file. But don't forget to make an empty row every 10, 12, 15, 20, or however many words you are putting into each word search. Then save again and it is ready to use.