I do a lot impromptu spreadsheets on my laptop when I’m trying to decide something — what’s the best price for different sizes at different online stores, whether it’s going to be cheaper to fly or drive somewhere, etc. Today I was looking at flights vs driving and I was getting tired of looking up dates, so I wanted a handy calendar right on the spreadsheet to refer to. I looked it up of course and sure, there are little programs you can get that will do that and long involved help processes to make a calendar in Excel, but really all I wanted was a static calendar right there to look at. Here’s what I did to make that happen:
For those familiar with these applications, in summary what I did was
- Open up Gadgets and get the simple Calendar – this will not work with the calendar on your Taskbar because it goes away when you try do a screenshot of it.
- Enlarge the Calendar Gadget and set it to the month you want in your spreadsheet.
- Start the Snipping Tool using Rectangular Snip setting, and grab a screenshot of the calendar.
- Paste it into your spreadsheet.
[Update for Windows 10: Gadgets have been discontinued, so the easiest way to get a small calendar screenshot would be to search online “calendar October 2016” or whatever month, click on Images or Image Search, choose the calendar you like and use the Snipping Tool to grab that image]
Here is a detailed tutorial:
Now open up the Snipping Tool (Start Menu or All Programs/Accessories).
You may need to use the drop down arrow to choose Rectangular Snip, then hit New. Snip the calendar (if you have never used the Snipping Tool — you click and hold the mouse button, drag it over the area you want to select, let go of the button and the snip is ready to save or copy) and copy it. Then paste it in your spreadsheet by right-clicking where you want the calendar to be and choosing Paste. Done!