Create an Interactive Crossword Puzzle with Microsoft Excel

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/...

[@mellaniemerritt4411]

Very cool! Learning how to do this makes it easier to understand/use/apply the functions to other projects. Thank you :)

[@PerezerepL]

Nice! I was looking for something else and your video came up. I enjoyed it. Thanks so much.

[@OfficeNewb]

Glad you enjoyed it!

[@anniest-pierre6328]

This is so awesome! thank you!

[@GirishMalur]

Wonderful, Thanks for the awesome exercise.

[@OfficeNewb]

Glad you enjoyed it!

[@tyronesingletary9195]

I will use it at work at our next party

[@OfficeNewb]

You'll be the hit of the party. :)

[@MathiKrishnan]

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

[@OfficeNewb]

Hello Mathi - What is the error you are getting?
=IF(CONCATE(puzzle!O6:O13)=B1, 1, 0)

[@abudhabi4401]

Excellent, BUT how do I have the crossword without the answers for others to use?

[@hamidelbouabidi583]

please how can make the completed version looks like yours because in my case it still shows 2 worksheets

[@OfficeNewb]

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.

[@ctreeves08]

@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.

[@OfficeNewb]

Hello Cliff - Thank you for the shoutout. I'm happy to hear you are enjoying the courses.