How To Create a Weight Calendar

Dear Computer Lady,

First, thank you so much for this website. By reading your website, you have answered many questions that have enabled me to understand and use my computer. Thank you.

Second, my problem. I record my daily weight on a yearly datebook calendar. I have been manually listing my weight for the last six years.. I would like to use a computer calendar to list current weight but still have the record of the prior years. At the end of the year, I would like to be able to transfer the previous years to the current calendar and then continuing adding the daily weight. Is this possible? If so, how do I begin to list numbers only and be able to transfer to current year? If not possible, what, if any alternatives, can you suggest?

I have Windows 7; Dragon NaturallySpeaking 11.5 (which I am still learning); and Word 2007.


Dear Carolann,

I don’t know if doing this on a calendar program is possible, but I think I would do this in an Excel spreadsheet.

Just open Excel, create a new spreadsheet.

In the first column, list dates (without the year) January 1, January 2, and so on.

At the top of the second column, enter the year, then, in that column, enter your weight next to the date.

Each column would be a year, and each row, would be a date.

For example, the first row, would be your weight on January 1st. This way, you just look across the row to see your weight on January first each year.

At the end of each year, go back to the top of your spreadsheet, and start a new year in the next column.

If you don’t have Excel on your computer, you can always create the same spreadsheet in the free version of Office at


It’s Your Turn: What do you think?
…. Share your experience in the comments box below.

Elizabeth Boston is a Web designer, Social Media Consultant and managing editor of, “Ask The Computer Lady”.
Connect with

Previous Post

Which Tablet to Buy?

Next Post

How to Add “My Computer” to XP Start Menu