Everyone likes to fix crosswords. This is a very advantageous point that will come in handy in different locations of activity: to lure users to the resource, to check and also consolidate expertise in the time of teaching, and so on.

You are watching: Cell assignment crossword

Excel spreadsheets enable customers to “automatize” resolving crossword puzzles: they can immediately view the outcomes of the solution. Let’s develop them making use of traditional features.



How to make an interactive crossword in Excel

The standard Excel sheet is a set of rectangular cells that are not rather suitable for illustration crossword puzzles. So initially you need to make them square.

Select all the cells by pressing Ctrl + A. Right-click all over and also choose «Row Height». Set the worth to 18.

*

Change the width of the column by another way: grab the right edge of any type of cell and also move it to the left side, establishing the worth to 3.

*

At the exact same time, the width of all columns of the worksheet is readjusted.

Begin illustration the grid of the crossword puzzle. Select the forced quantity of cells. Set all the borders in «Font» team.

By the exact same principle, attract the whole crossword. Don’t forgain to put numbers of inquiries / answers.

*

Make up concerns for the crossword puzzle. Write them to the ideal of the grid.



How to make a crossword through checking in Excel

Create an auxiliary table through answers on a brand-new worksheet:

*

In «Introduced:» column, the answers gone into in the crossword by a user will be shown. Column "?" represents matches. Cell V8 displays the variety of correct answers.

Now glue the individual letters in the crossword into whole words by using «CONCATENATE» feature. Get in formulas in «Introduced:» column’s cells:

*

A user deserve to enter both lowersituation and also upperinstance letters. As a result, some problems aincrease. To avoid them, use «LOWER» feature. Place it in all cells before «CONCATENATE» feature.

For questions:

In cell C2:In C3:In C4:In C5:In C6:

The function converts uppercase letters to lowercase ones.

If a user enters a correct answer, figure 1 will certainly appear in column array D2:D6. In instance of an incorrect answer, 0 will show up. In cell D2 do it by utilizing «=IF()» function: =IF(B2=C2,1,0). For calculating the number of correct answers, =SUM(D2:D6) function is used in cell D7.

The variety of all correct answers is 5 in cell Sheet1!N7. If "5" appears in «Total» cell Sheet2!D7, it means that a user coped via resolving the crossword. The message “DONE!!!” (for example) is shown on the display.

If there is one more number in «Total» cell, “Still think …” is presented.

Implement the task making use of «IF» function in cell O10 on Sheet1:

Let’s show a user just how many type of answers are left to guess. The complete number concerns is 5 (in cell Sheet1!N7) . Hence, the formula will certainly be as complies with in cell N11 on Sheet1:

=N7-Sheet2!D7

Wright here Sheet2!D7 – is the variety of correct answers from the auxiliary table.

To check the functionality of the formulas, enter all the answers right into the grid of the crossword. You’ll get the adhering to result:

*

Hide the correct answers from a user. Rerelocate them from the crossword grid on the second worksheet. Select the rows of the auxiliary table. Go to «DATA» tab - «Outline» group. Use «Group» tool.

*

In the opened up home window, pick the check box in front of «Rows» entry.

The structure icons and also the minus symbol will appear in the left area of the worksheet.

*

Click on "-" symbol. The auxiliary table information will become invisible.

Next off, go to «REVIEW» tab. In «Changes» team, uncover «Protect Sheet» button. Asauthorize a password in the opened up window. Now an unauthorized person (that doesn’t know the password) will certainly not have the ability to open the auxiliary table and view the answers.

*

If a user tries to open up the answers, the regimen will certainly show the complying with warning: "You cannot use this command also on a protected sheet...".

See more: Pets For Adoption At Cat Nap From The Heart Inc, Catnap From The Heart Inc

*

The fundamental occupational on developing the crossword puzzle is over. You deserve to beauticompletely finalize the worksheet, include a name, readjust the fill shade of the grid, brighten the borders of cells, and so on.