Everyone likes to fix crosswords. This is really useful thing that will certainly come in handy in different areas of activity: to attract users come the resource, to check and also consolidate knowledge throughout teaching, etc.

You are watching: Cell assignment crossword

Excel spreadsheets enable users come “automatize” solving crossword puzzles: lock can automatically see the outcomes of the solution. Let’s develop them using typical functions.



How to do an interaction crossword in Excel

The standard Excel paper is a collection of rectangle-shaped cells that space not quite suitable for drawing crossword puzzles. So an initial you must make castle square.

Select every the cells by pushing Ctrl + A. Right-click anywhere and also select «Row Height». Set the value to 18.

*

Change the broad of the obelisk by an additional way: take the best edge of any type of cell and move it to the left side, setup the worth to 3.

*

At the exact same time, the width of every columns that the worksheet is changed.

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

By the exact same principle, attract the whole crossword. Don’t forget to placed numbers of questions / answers.

*

Make up inquiries for the crossword puzzle. Create them come the right of the grid.



How to do a crossword with checking in Excel

Create an assistant table v answers on a brand-new worksheet:

*

In «Introduced:» column, the answers entered in the crossword puzzle by a user will be displayed. Shaft "?" represents matches. Cell V8 displays the variety of correct answers.

Now adhesive the individual letters in the crossword into whole words by utilizing «CONCATENATE» function. Enter formulas in «Introduced:» column’s cells:

*

A user can go into both lowercase and uppercase letters. Together a result, some troubles arise. To avoid them, use «LOWER» function. Ar it in all cells before «CONCATENATE» function.

For questions:

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

The role converts uppercase letters to small letter ones.

If a user beginning a exactly answer, number 1 will show up in column range D2:D6. In situation of an incorrect answer, 0 will appear. In cabinet D2 carry out it by utilizing «=IF()» function: =IF(B2=C2,1,0). Because that calculating the number of correct answers, =SUM(D2:D6) role is offered in cabinet D7.

The number of all exactly answers is 5 in cell Sheet1!N7. If "5" shows up in «Total» cabinet Sheet2!D7, it means that a user coped with fixing the crossword. The message “DONE!!!” (for example) is shown on the screen.

If there is an additional number in «Total» cell, “Still think …” is displayed.

Implement the task using «IF» function in cell O10 ~ above Sheet1:

Let’s present a user how many answers space left to guess. The complete number questions is 5 (in cabinet Sheet1!N7) . Hence, the formula will certainly be as follows in cabinet N11 ~ above Sheet1:

=N7-Sheet2!D7

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

To inspect the functionality of the formulas, enter all the answers right into the grid of the crossword. You’ll obtain the complying with result:

*

Hide the exactly answers native a user. Eliminate them from the crossword network on the 2nd worksheet. Select the rows the the auxiliary table. Go to «DATA» tab - «Outline» group. Use «Group» tool.

*

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

The framework icons and also the minus prize will appear in the left field of the worksheet.

*

Click ~ above "-" icon. The assistant table data will end up being invisible.

Next, walk to «REVIEW» tab. In «Changes» group, find «Protect Sheet» button. Entrust a password in the opened window. Currently an unauthorized person (who doesn’t recognize the password) will not have the ability to open the assistant table and also see the answers.

*

If a user do the efforts to open the answers, the routine will show the complying with warning: "You cannot usage this command ~ above a protected sheet...".

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

*

The straightforward work on creating the crossword puzzle is over. You have the right to beautifully finalize the worksheet, add a name, change the fill color of the grid, brighten the boundaries of cells, etc.