There are Easter Eggs in this Excel file!!!

Posted on April 18th, 2014 in Excel Challenges - 68 comments

Hello Friends…,

Happy Easter 2012

It is Easter time again. Every year, we at Chandoo.org celebrate Easter by hunting for eggs (not in the wild, just in the Excel workbooks). This year too I have hidden 30 Excel tips in a workbook. You have to solve 3 puzzles to find them. So what are you waiting for. Go ahead and hunt for them eggs.

Click here to download the Easter eggs file.

I am sure you will enjoy them :)

If you are in mood for more adventure, hunt for the Easter eggs from past  2013, 2012, 2011, 2010 & 2009.

And yeah, its not too late to discover the Hidden Angry Formulas game in Excel (2007 and above)

Easter Egg photo from tillwe.

Your email address is safe with us. Our policies

Written by Chandoo
Tags: , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

68 Responses to “There are Easter Eggs in this Excel file!!!”

  1. chirayu says:

    I got puzzle 1 & 2 but cant get 3

  2. Xiq says:

    ^_^
    it feels like cheating though…

  3. Mike Daniels says:

    If I hadn’t learned about Formula Auditing from Chandoo, I doubt I would have solved all 3; but I did. However, I don’t totally understand the 3rd clue. Much fun though!

  4. Chris Macro says:

    Puzzle 3 was awesome!! Super creative Chandoo :)

  5. Jay says:

    i could not understand the puzzle :-)

  6. Tarun says:

    Hi Chandoo!!!

    I am a silent follower on your tricks. Have learned immensely from your blogs.
    I was able to crack it (and surprisingly, within <10 mins time). This one was more on logical thinking whereas I feel that the hidden egg puzzle from last year were a lot more fun to track.
    Keep up the Awesome work!!!

  7. Krishnasamy Mohan says:

    Hi Chandoo!
    Though the eggs are as old as more than five years, still I feel the taste! Thanks for renewing. Always Enjoy the Easter Eggs.

  8. Mike says:

    Ok, I’m racking my brain trying to figure out Puzzle 3… I dont want answers.. but maybe a hint??
    I tried a bunch of dates d-mmm , including the hint dates and Easter etc… still nothing.
    Hints anyone?

  9. Henk says:

    I solved all 3 and i see the eggs, but i can’t click on the “eggs” because the sheet is protected. What do i do wrong?

  10. Debraj Roy says:

    Funny .. and enjoyed too…
    Still one puzzle is unsolved from my end.. :(

    “Why top 10 links are from from old topic.. ” :)

    • Chandoo says:

      The real Easter eggs are the puzzles. So I spent most of my time on creating them. By then it was time to publish, the tips have to be rehashed. But they are good ones too :)

  11. Manish says:

    Puzzle 3 was very clever. Teaching my fourth graders to look for patterns helped.

  12. Somendra Misra says:

    Solved….I like the first one … :)
    3 one was creative….

  13. Amit says:

    Done in 10 min, without any cheatcode….. Excellent stuff

  14. Manjunath says:

    Done :-)

  15. Solved only Puzzle 2…

    Not idea about remaining two… any hint guys..

  16. Anup Agarwal says:

    Yayy yayyy…. Thank you Chandoo… A hot summer afternoon made fun…

  17. Olímpio says:

    Mágic Chandoo, did & enjoyed. Would you come to Brazll to world Cup? If no, can you propose a Cup table?

  18. Wainers says:

    Brilliant, Chandoo, and thank you for taking the time to enrich all our lives.

  19. hbelal says:

    very creative ideas.

  20. […] the Easter bunny didn’t bring you anything, you can find hidden eggs in Chandoo’s Excel tips […]

  21. Kittu20 says:

    I cant click on the eggs. They are protected. I have tried using this on my desktop but couldnt click on them. Please help

  22. Luke M says:

    Very nice, thanks Chandoo. :)

  23. Waqas says:

    I have wrapped the text for 3rd puzzle but could not get the answer… any hint?

  24. CC says:

    I got 2 & 3 but dont understand 1 at all :(

  25. Jeff says:

    the problem is once you unlock the eggs the sheet is protected so you cant “use” the eggs (trying not to give away the secret).

  26. Bryan says:

    I was able to get the Eggs tab to appear, but unprotecting does not work for me. I enter through the password box, but this does not unprotect.

  27. CBZ323 says:

    That was fun. Thanks for the fun easter egg hunt!

    I also cant unprotect the sheet to click on the links.

  28. Leonardo says:

    Done!
    Keep it simple and it’ll work!
    Nice message.

  29. Ellen says:

    Struggling with #3 and I can’t unprotect any worksheets, as everything is password protected – with a password. Is there a different approach for Mac users?

    • Ellen says:

      Nevermind – I figured out #3, but I can’t unprotect the Eggs worksheet to make the links clickable. I’ll just copy & paste.

  30. MF says:

    Interesting game.
    I am wondering if you have protected the “Eggs” intentionally so that you know if we could really solve all the puzzles and find the “Eggs”. ;p

  31. Ankita says:

    Not able to unprotect the sheet :(

    Puzzles were awesome but only with the help of formula auditing :)

  32. Chandoo says:

    @All.. When I tested the file, I could click on the links in Eggs sheet. Since some of you are facing issues, follow this:

    1. Unprotect the eggs sheet with password easter2014
    2. Click on the links.

    Alternatively, follow the links here too:

    http://chandoo.org/wp/2013/01/16/top-10-formulas-for-aspiring-analysts/
    http://chandoo.org/wp/2011/08/08/must-have-excel-keyboard-shortcuts/
    http://chandoo.org/wp/2009/11/03/make-better-excel-sheets/

  33. Karthik says:

    Below are the answers

    1) Type : (correct value) in column C8……. Puzzle 1
    2) Type : (184) in column C17……. Puzzle 2
    2) Type : (1221) in column C23……. Puzzle 3

    • James says:

      2 was that simple? Dang, I made a function to loop through the shapes on the page to get the name of the scrollbar and then made another to change its maximum value

  34. Suresh Kumawat says:

    Just did it.. A mind blowing puzzle.

  35. Pintu says:

    Hi Chandoo,
    Must say it was very creative. As always you used the very simple to make it look complex.
    Got all 3, the first one is very literal in meaning.

    Great Job. Thanks for the easter eggs.

  36. Ashwin says:

    Hello Chandoo…got the answers for 1 & 2 but couldnt just figure out the 3rd one ..can you please gimme one more clue

  37. Just me... says:

    Solved the puzzle, but unable to open the links on the 2nd worksheet.

  38. Ronnie says:

    I can’t figure out how to adjust the Properties of the scroll bar in #2 to allow me to increase the range. Sure, I could just type 184 in cell C17, but seems to be cheating.

    • Hui... says:

      @Ronnie
      Simply type the value into the cell

      • Ronnie says:

        Hui,
        The instructions say “Use the scroll bar to select 184″. If I just type “184” in cell C17, I achieve the desired results, but I have not followed the directions. I have also not learned anything new in Excel. I was expecting to have to modify the scroll bar properties to allow for a broader range. But I cannot figure out how to select the scrollbar to even see its properties. That may be because the sheet is protected. Should I just “get over it” and move on? :-)

        Thanks,
        Ronnie

        • Hui... says:

          @Ronnie
          I am not privy to Chandoo’s logic, So I believe so

        • Chandoo says:

          As Hui pointed, the correct way to solve this is to enter value in C17. I wanted to showcase the nature of relationship between form controls & linked cells thru this. Even though one of them stops at 183, you can change the other (and effectively have scrollbar at 184).

Leave a Reply