A New Year Resolutions Template that Kicks Ass

Jennie, a sweet and ambitious lady set out to do 101 things in the next 1001 days. She took the inspiration from Day Zero Project. Not stopping there, she prepared a cute little excel sheet to keep track of all these new year resolutions and sent it to me.

I think this is a swell excel template if you want to keep track of your goals or new year resolutions or just manage a list. See it for yourself.

Related Templates and Downloads

Sign-up for our FREE Excel tips newsletter:

Here is a smart way to become awesome in Excel. Just signup for my FREE Excel tips newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:

Nice work Jennie – hope the weather improves because I certainly can’t do #26 anytime soon…

Chandoo – a silly question – how do you format the sheet to show no grids etc – I notice that all your examples have a clean white sheet…I paint the background to white so not sure if you do something else?

Jennie your spreadsheet is easy to use and very nice to look at, great job!

I am working on a project that could use this technique, however I’m having an issue copying the checkboxes down each row. All the links point to the original checkbox’s cell. Can anyone help, or do I have to manually change each box?

Hej! I LOVE this. The only problem I’ve encountered is being able to check the boxes. They work when the document is read-only. When I “save as” so I can fill in the cells, I can no longer check the boxes. I suck at Excel..ha ha! I thought it could be that I use Ubuntu with Open Office, yet I would think I would have a problem in read only as well if it were that. Ideas?

[…] with other long term goals, Excel can make the magic happen. Fellow MVP Purna Duggirala posted an Excel spreadsheet template that takes advantage of conditional formatting and check-boxes to create a list of goals and track […]

Hi All,
Did anyone noticed that columns H, I’s formatting??
whatever you type, just goes invisible, (once u out of the cell), but the value stays in the cell!!!
Awesome custom format ;;;
I love it! Let me play with my seniors @ office with this cool format trick

I read Jenny’s article a year and a half ago… a little over 450 days to my 30th birthday. Inspired, I made my own list of 45 things to do in 450 days…the day I turn 30. I covered ~55% of the goals, and reading 45 books was one of the most time consuming, yet rewarding. I exercised more, took up pottery classes, tried new things and couldn’t have asked for a more rewarding experience. I dint get to watch 5 plays (got to 4) and swim once a week, for 50 weeks, volunteer for causes and spend ~60hrs (got to 20, but have enrolled in a program which is more sustained now, and hopefully a more longterm association), watch the husband play local football matches once a month… but then again, its a working list, and I loved the positivity it brought to me.

Thanks So Much Jenny! I hope you got to do most of the stuff on your list too.

This birthday, I’ve made a list of 30 things I want to do over the year. Cant wait!