How to Create a Crossword Puzzle in Excel - Tutorial
HTML-код
- Опубликовано: 30 апр 2017
- Crossword! Learn how to make a crossword puzzle in Excel! This way your puzzle can have the words you want, for the theme you want and formatted exactly how you like. Watch this short MS Excel tutorial to learn how to make your own crossword game using Microsoft Excel!
Make a crossword puzzle in Excel for office party, birthday, vacation, kids, wedding shower or bridal shower, bachelorette party, retirement party, holidays, etc!
Click here to read our step-by-step article on this: yacostasolutions.com/crosswor...
And if you need ideas for words you can use, take a look at our lists of themed word lists to help you out: yacostasolutions.com/topics/w...
For other word puzzle game ideas using Excel, take a look at these other video tutorials:
How to Create a Word Search Puzzle in Excel - Tutorial: • How to Create a Word S...
How to Create a Bingo Board in Excel - Tutorial: • How to Create a Bingo ...
How to Make a Word Jumble in Excel - Tutorial:
• How to Create a Word J...
If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: yacostasolutions.com/newsletter/
*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: yacostasolutions.com/MS365
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: yacostasolutions.com/camtasia
Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends - it really helps us out 😊
To catch our Excel tutorials as they come out, subscribe to this channel by clicking: yacostasolutions.com/youtube
Thanks!
*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!
#YAcostaTutorials
So clear cut. Needed help with a project! Thank youuu!!!
I'm so happy this helped you! Thanks so much 🙂
Thank you for posting this video! It was a life saver for an online class project.
That's awesome! I'm happy the tutorial was helpful. Thanks for sharing that :)
Nicely done!
At first I thought your approach was very illogical, but after a couple of minutes I realised why you have done it that way, and it makes sense.
This is a great way to achieve a simple crossword in very little time, and quite easy to edit/adapt, too.
Thanks a lot.
My husband says the same thing about my way of doing things 😂 I’m happy you hung around long enough for it to come together 🙂 Thanks!
STRAIGHT TO THE POINT AND VERY CLEAR...THANK U SOOOO MUCH :)
I’m happy this was helpful for you, Shannon! I hope your puzzle is a lot of fun ☺️
Fantastic and well explained. It is amazing how flexible Exel is and I remember back in the day I think it fitted on one floppy disc too! Many thanks for making this!
Thank you so much, Anthony 😊
Thank you! Appreciate your help. You had very clear explanations!
Thank you, Linda. I really appreciate your kind feedback. Happy this was helpful to you 🙂
Yes! This is exactly what I need. Thank you.
That's awesome, Laurie! I hope your puzzle is a great success 🙂
Thank you, that was so clear and helpful!
Thanks, Lynn. I'm happy you liked this 🙂 Hope your puzzle is awesome!
Thank you for this very helpful tutorial! ❣️
Thanks, Aynah! I'm happy this was helpful for you 😊
THANK YOU SO MUCH, REALLY HELPS ME A LOT
That’s great, Nurul! I’m happy you found it helpful 🙂
What an easy elaboration, i could follow through! thanks for sharing.
Thanks so much, Cherishaaa! I'm happy this helped you 🙂
THANK YOU VERY MUCH!!!
Thanks! Happy you liked it 🙂
Thanks so much this is so helpful!
Thank you, Sharon! I'm happy this was helpful to you. Hope your puzzle is a success 🙂
Thank you so much 👍
You're welcome! Glad you enjoyed this.
Thanks for letting me know you liked this video and make sure to catch our other free tutorials too! Thanks
Wow. Thank you so much !
Thanks, Marius. Happy you liked this 🙂
Thank you so much! :D I had an assignment to do with creating a crossword puzzle, This was very helpful.
Awesome! Glad it helped!
Thank you. This helped me alot.
Thanks, Hazel. Happy it helped 🙂
Wow I did not know microsoft excel is capable of this! I'm trying this right now
Awesome! Have fun with your crossword :)
thank you so much for sharing this tutorial it was a HUGE HELP
Awesome, Leaha! I’m happy this helped you 🙂
thank you so much 🙏💕
Awww. Thank you! I'm happy you liked this 🙂
Wow excel is so flexible. I didn't know that we can create like this.
Hi, Francis. Happy you liked the tutorial! Spreadsheets really are like a blank canvas 🙂
Thanks a bunch! :D
Thank you! I'm happy this was helpful for you 🙂
thank you! :)
Thanks, Kelly! I’m happy you liked this 🙂
Thanks a lot
Happy this helped you 🙂
wow. i am a slow learner but i could follow you step by step. I am making a "Bible Crossword Puzzle: Words that begin with A." I am definitely praying for ALL of those who are in this COVID-19 pandemic. Perhaps I can make it through to Bible words that begin with Z, and bless those of us who are Staying at Home. May God bless you through this Holy Week, from Jesus' suffering to his Resurrection.
That's awesome, Coleen! I'm excited for you and happy this video was able to help you. Also, I'm sure if you make it all the way to the Z's, your church could maybe reuse your puzzles in their children's Sunday school. Stay safe!
thank you so much you saved me
Glad I could help! 🙂
Thank you so much! This helped me out in my Russian class
That's awesome! Happy this helped you 🙂
Thanks for an excellent tutorial. By the way, I don't have Excel, but I was able to adapt your instructions easily to OpenOfficeCalc.
That's great! I'll need to check out OpenOfficeCalc. I don't yet know much about it. Thanks for brining it to my attention.
Very kind thx..will try it out soon;I would like to insert pics into the crossword,any tips;also how to align the numbers from box to box when inserting them..any tips thx
Hi, Steven. Thanks for the compliment 🙂 I really appreciate it. One thing you can do to help you better align the text boxes to each other is using the Align Center options under Shape Format (you'll see this menu populate whenever you select one of the text boxes).
Select all of the text boxes by row (one row at a time). Make sure they are as close to the top edge of the cell and click on Align Middle.
Repeat the same thing for the columns (selecting one column at a time) and click on Align Center.
I hope this helps and hope your puzzle is a success!
Nice
Thank you 🙂
This was helpful. But I need it on a Word page. Is it possible to paste this in MS word afterwards
Love u
Awww. Thank you 😊
Hi, I need some help. I need a crossword checker when I make the puzzle with Excel. Something that when people submit it back to my website, I have a tool/solution that automatically checks it for the answers. Do you have an idea on how that could be done? We want to launch a crossword contest and we cannot go through every puzzle and manually check them. We need something that we can plug the solved crosswords in and have it checked for us. Any help would be great!
I was trying this and found here
So glad you found this! 🙂 Thanks!
what if I need a wider area? that margin is too small.
Hi, Miriam. If you make your margins wider, you may just need to make your squares smaller to fit longer words and/or make the puzzle area smaller if you want to fit the clues on the same page. Or you could print the clues on a separate sheet.
If you plan to print it, make sure to test it so you know if the squares are big enough for people to write in them.
You may want to try changing your view to Page Layout (View tab / Page Layout). This will make it easier to see your page as it would print (not sure why I didn’t use that on the tutorial - sorry for that). Page Break Preview can help too.
Hope this helps. Please let me know if you still have questions. Thanks
Please tell me how can I copy it on power point presentation 😕 !!
Hi, DKD Queen. Thanks for watching my video :)
Give this a try to add your crossword to a PowerPoint presentation: select your entire crossword puzzle in Excel, copy it and then, in your PowerPoint slide, right click and choose Paste as a Picture. Hope this helps. Please let me know if you need more help.
And good luck with your presentation!
Hi. I'm guessing you've probably copied this to PowerPoint by now, but, thought you might be interested in a recent tutorial I did on saving an image from Excel - ruclips.net/video/9KIW9PnYETs/видео.html
I made one and I printed it, it was OK but why was there no color on it?
Hi, Shishilan. And thank you for watching my tutorial :)
When you say no color on it, are you saying that the black background didn’t print for you? As long as you use the Fill Color feature, it should work.
If you mean why there is no color in the boxes for the letters, it’s because it’s not necessary. In most cases, it’ll look fine, be one less step and can save ink (if printing) to use no color in them and default the color of them to the color of the paper or the spreadsheet.
If you’re asking why it’s only black and white, then it’s for a couple reasons. But you could use a different fill color if you prefer.:
1. Black and white is a popular color scheme for crossword puzzles
2. Black ink is cheaper than color ink, and for someone who may be printing several of these, this could be helpful (a gray background would be even cheaper to print!)
I hope this answered your question. If it didn’t, please let me know. And thanks again!
Did you mean to "clear" the game instead of delete at the very end of your video?
Hi, Jane. Yes! 🤦♀️ That's what I meant. I pressed the Delete key to clear all the text and ended up saying that. Sorry for the confusion and thanks!
Like this tutorial? Make sure to grab your FREE pdf list of top Excel keyboard shortcuts: yacostasolutions.com/newsletter/
How to erase all letter
Hi, Noviel. I think you're asking about how to delete all the letters in the crossword once you've entered them so that you end with a blank crossword puzzle? If so:
You'll first want to make sure you either make a copy of the filled crossword or write down the answers somewhere. In the video, I made a copy in a new tab inside the same workbook, but you can always save your copy to a different workbook. This is so you later don't forget what the answers are.
Next, you'll highlight only the crossword area and press Delete. This will remove the letters, but not the numbers in the text boxes.
If you have a moment, you can take a look at the video around 9:14 minutes in. You'll be able to see how I walked through these steps.
I hope this answers your question. Please let me know if you have more questions (or if I misread your question).
And thanks for watching!
This is bad!!!
I’m sorry you didn’t like the video :( Do you have any suggestions on what you would have liked to see? Thanks