Help CenterYou have a list of words for a word search and you want to quickly add a blank row for each puzzle on each page, this can be done fairly easy, just follow the steps below.
In this example we have a list of 1200 words, that we will be using in a 120 page word search. So each word search will have 10 words.
In Column B put in the numbers, 1 then 2. select both of them. Put your mouse over the handle on the bottom right of the highlighted cells, left click and drag it down until you are to your last word.
It should look like this below.
The next step is to enter the number 10, then under it 20 (we are entering 10 and 20, because we are doing 10 words per puzzle, if you are doing 15 words per puzzle, then you would enter 15 and 30. If you were doing 18 words per puzzle, then you would enter 18 and 36, etc.).
Select those 2 cells like you did above, put your mouse over the handle on the bottom right of the selected cells, left click and drag them down until you are to the number 1200 (if you are doing larger or smaller puzzles, more or less pages, in the end, you are going to the row number you did in the previous step, which in this case is row 1200).
As you drag it, it should show you what number you are at.
Let go of the mouse button.
Now you want to select all of the sheet, click the button on the corner.
Click Data on the top menu, then click sort, in the drop down menu, select "Column B" to be sorted by, press "Ok". Below you see you have a blank row in column A, every 10 spots.
Next, click on column B so the whole column is selected. Right click and pick delete. Save your csv file now and it is ready to use.
