How to make a crossword in Excel using standard functions
How to make an interactive crossword in Excel. The standard Excel sheet is a set of rectangular cells that are not quite suitable for drawing crossword puzzles. So first you need to make them square. Select all the cells by pressing Ctrl + A. Right-click anywhere and select «Row Height». Set the value to Excel Crossword Puzzle Step 1: Clean Slate. Right now you should have a brand new excel sheet. Before doing anything to the excel sheet, I Step 2: Formatting. It will better if we first start by formatting the cells. Select a bunch of cells and click on the Step 3: Entering Your Crossword.
Everyone likes to solve crosswords. This is an extremely useful thing that will come in handy hwo different areas of makr to attract users to the resource, to check and consolidate knowledge during teaching, etc. The standard Excel sheet is a set of rectangular cells that are not quite suitable for drawing crossword puzzles.
So crossworrd you need to make them square. Right-click anywhere and select «Row Height». Set the value to Change the width of the column by another way: how to make crossword puzzles in excel the right edge of any cell and move it to the left side, setting the value to 3. Begin drawing the grid of the crossword puzzle. Select the required quantity of cells. Set all the boundaries in «Font» group. By the same principle, draw the entire crossword.
In «Introduced:» column, the answers entered in the crossword by a user will be displayed. Column "? Cell V8 displays the number of correct answers. A user can enter both lowercase and uppercase letters. As a result, some problems arise. If a user enters a correct answer, figure 1 will appear in column range D2:D6. In case of an incorrect answer, 0 will appear. The number of all correct answers is 5 in cell Sheet1! If "5" appears in «Total» cell Sheet2!
D7, it means that a user coped with solving the crossword. The total number questions is 5 in how to become popular on stardoll Sheet1!
Hence, the formula will be as follows in makw N11 on Sheet To check the functionality of the formulas, enter all the answers into croseword grid of the crossword. Hide the correct answers from a user. Remove them from the crossword grid on the second worksheet. Select the how to make crossword puzzles in excel of the auxiliary crosssord.
Use «Group» tool. In «Changes» group, find «Protect Sheet» button. Assign a password in the opened window. If a user tries to open the answers, the program will show the following warning: "You cannot use this command on a protected sheet The basic work on creating the crossword puzzle is over.
You can beautifully finalize the worksheet, add what is a good severance package name, change the fill color of the grid, brighten the borders of cells, etc. How to make a mske in Excel using standard functions Everyone likes to solve crosswords.
Introduction: Excel Crossword Puzzle
The standard Microsoft Excel sheet has a set of rectangular cells that might not be stable for drawing crossword so you have to make them a square. Select all the cells by pressing Ctrl+A. Push right click anywhere and then select “row height”. Then set the value of Create a crossword in excel with this guide as it is quite easy. Let’s move ahead.
In this Instructable, I will be showing you how to make an excel crossword puzzle. This is very easy and simple to make and In the end, I'll show you how to check if the answers are correct. Right now you should have a brand new excel sheet. Before doing anything to the excel sheet, I suggest that you take a pen and paper and draw a rough grid for the crossword. If you are confident you don't need to draw the grid then okay. It will better if we first start by formatting the cells. Select a bunch of cells and click on the Format button in the home section.
There, set the row height to be about 25 and the row width to be around 6 this way you get the cells to be almost square. Now, turn on caps lock and enter the crossword, One letter per cell.
When you are done with entering the crossword choose any colour of your choice and highlight the text with it. After that consider putting a border for the Text by selecting the borders option. Now that the crossword is ready let's start typing the questions. Make the headings bold and maybe increase the font size. Just put in the number near the word bold it and add a border while you're at it.
From this point onwards we are gonna make use of excel formulas and create an automatic checking system. The first thing you need to do for that is to add a sheet.
Click on that, this means you are creating a new excel sheet. In the second column type in all the answers near the correct number. Answers entered in the crossword will be shown in that column with the magic of excel formulas. In this step, we will check if the answers are correct.
If the user enters the letters in capital there may be a problem when checking so, we convert all of them into lowercase. This command puts all the letters into one full word. Inside the brackets Sheet1! K12, The first part is Sheet1! Do the same for the rest of the word and you should have something similar to the picture I have. Now we will check if the answer given is correct. The first word is IF , with this command, we will see if both the cells are the same.
After that, I have entered a 0 to say if the condition is not true then print 0 in the cell. Select all the values under Status. Under Formulas click on the auto sum button, and you will get all the values added up!
Now go to Sheet1 over there pick a cell where you can tell the user how many words he has left to find you can do that by putting in this formula. D9 is the cell for this, you should select the cell where all the values are added up. Hit enter and see the value appear.
Merge a couple of cells near that and type in this formula:. Here we are basically saying if the number of words left is equal to 0 then say "You are done" else say "left". We are almost done! Just go to the sheet where you have all the answers typed in and select the whole table, under data select group and press ok. Now you should see a - sign, if you click on it the whole table will get minimized.
Now under review click on the Lock sheet button while the table is minimized and enter in a password. That's it your sheet is locked now nobody can cheat by looking at the answer sheets. Just a few finishing touches now. That's it! You are done. I made it without changing any content , but I learned a lot from this tutorial, Thank BattleWarrior for sharing.
Introduction: Excel Crossword Puzzle. By BattleWarrior Follow. About: Hi! I'm a DIY enthusiast. I usually do projects related to computers or microcontrollers. This is very easy and simple to make and In the end, I'll show you how to check if the answers are correct Supplies: Microsoft Excel Pen and Paper. D9 here as you may have already seen Sheet2! Hope you liked this instructable. Did you make this project? Share it with us! I Made It! Aquaponics for Everyone! Garlic Gardening by DanPro in Gardening.