Create an Interactive Crossword Puzzle with Microsoft Excel
Vložit
- čas přidán 21. 08. 2024
- With a little cell formatting, a sprinkle of Excel function magic and conditional formatting you can create an interactive Crossword Puzzle in Microsoft Excel.
DOWNLOADABLE EXERCISE FILE
www.officenewb...
FULL EXCEL COURSE
www.udemy.com/...
Very cool! Learning how to do this makes it easier to understand/use/apply the functions to other projects. Thank you :)
Nice! I was looking for something else and your video came up. I enjoyed it. Thanks so much.
Glad you enjoyed it!
This is so awesome! thank you!
Wonderful, Thanks for the awesome exercise.
Glad you enjoyed it!
I will use it at work at our next party
You'll be the hit of the party. :)
Hello Kyle,
Thanks for the interesting exercise.
Need a help in my case, I am getting value error ( Excel 2016 ) while using the formula as you mentioned.
But it works in the below method.
=IF(CONCATENATE(puzzle!O6,puzzle!O7,puzzle!O8,puzzle!O9,puzzle!O10,puzzle!O11,puzzle!O12,puzzle!O13)=B1,1,0)
Am I missing something?
Thanks,
Mathi Krishnan
Hello Mathi - What is the error you are getting?
=IF(CONCATE(puzzle!O6:O13)=B1, 1, 0)
Excellent, BUT how do I have the crossword without the answers for others to use?
please how can make the completed version looks like yours because in my case it still shows 2 worksheets
You can always click on the link in the description of this video and download the completed version so maybe see what you need to do.
@OfficeNewb.com, this is awesome, thank you!
For anyone looking to advance their office skills, I highly recommend Kyle. I've taken all his courses and loved them.
Hello Cliff - Thank you for the shoutout. I'm happy to hear you are enjoying the courses.