Shrinking part of a worksheet to give better view of data

Hi,

I have a booking sheet, part of which is a calender view showing all the days of a month.

Ideally I would be like to be able to view all of the booking chart data at once to see when rooms are available.

What's the best way of doing this and is it something that may be best done as a macro? (eg set it so that by pressing a button it gives me a screen shot of data all on one page?)

I have attached an example, I would like to be able to see all the data in C2:AG54 as a screenshot all on the same page if possible (as if I had selected 'fit to page in print preview).

The attachment is just an example, the real workbook goes across to B with various info which I why I need to separate this section)

Thanks