Sudoku creator and solver
Our newest free Excel tool is a Sudoku game. Sorry it’s taken so long, we didn’t realise how difficult it would be to make it do everything we wanted to do whilst also performing well in Excel.
We have given you 6 levels of puzzle to enjoy, ranging from easy to extreme. With an ‘Oh Dear’ category which gives you the opportunity to try a puzzle based on the worlds hardest Sudoku.
To help you improve your skills, or to move past a stuck position we have also provided you a number of options to help you…
- Check that your answers are correct so far
- Highlight each number in turn to help you to focus on any gaps
- Highlight the easiest numbers to focus on next
- Reveal another number at random
Once you’re finished, or if you give up you can then solve the puzzle to show the complete grid. At this point you can either unsolved to return back to where you were when you clicked Solve, or press Reset to return the grid to the original puzzle you were presented with.
Solving existing Sudoku puzzles
If you want to use the tool to help you solve your other Sudoku puzzles then you can do this. Simply delete the data in the grid, and then click Solve. It will give you this popup which you can click yes to. Then you will be shown the solution.
If you spot any bugs or would like any new features added to this Sudoku game then please leave us a comment below and we will incorporate it.
Enjoy! 🙂
9 Responses
Is there any chance you could share the code for the Sudoku creation? This is very interesting and extremely well done
I’m afraid I don’t share the code but I tried multiple approaches for creating the puzzles and tore my hair out on numerous occasions. Finding a way to create Suduko puzzles which only have a single solution, and don’t require guesswork, and are created in a sensible amount of time is TRICKY!! (and fun) 🙂
terima kasih macro excel tools, I want to creat inventory system for drug medical to storage and medical pharmacetical
Great idea Gozali. Can you post it on my facebook group please so I can keep track of all the new ideas for tools. Any details about how the inventory system would need to work would be much appreciated, or similar tools out there. Phil
https://www.facebook.com/StraightLineSolutionsUK/posts/1081819441945464
My Excel doesn’t support Marco so I have to use my laptop great job
I just published a step-by-step with VBA code to create Sudoku in Excel: https://excelmacrofun.blogspot.com/
Thanks for sharing Victor. I took a look and it seems like a good guide. One question though, can you guarantee that your puzzle is solvable and only has 1 solution if you simply take numbers away at random?
Hi Philip, that’s a very good question that I’ve been thinking through for some time.However, after reading a good article I found online, I learned that method is the best approach. After a certain number of cells removed though, it could create conflicts and lead to more than one solution as you mention. I will try to upload the excel (not sure if I can do it there in the blog), so that people can test. Please have a look at this article if you are interested in the different ways of generating and solving Sudoku puzzles::http://theinf1.informatik.uni-jena.de/publications/sudoku-weller08.pdf
As a new feature. The ability to enter numbers from another puzzle. I entered the numbers from another puzzle. It would solve it. First it said the numbers had been changed. Then it asked if I wanted to solve for the new numbers. But, I was not able to unsolve back to the numbers I put in.