I have a worksheet set up to show a report for a specific date or a specific month. When I add a single date (ex. 9/29/2016) everything is fine. But when I load my calendar and insert the entire month it puts a small calendar in the active cell but it will reformat all my column widths to match the width of the calendar days.(ex. Sunday will become A1, Monday B1, etc.) Is there a way to insert the calendar in to just one cell instead of it becoming 7 separate columns? Any help would be greatly appreciated.
This is what the sheet looks like before adding the calendar.
http://imgur.com/xekaH0s
This is after adding it.
http://imgur.com/hadGq0U
I need to find a way to fit that calendar into one cell.
Bookmarks