Page 2 of 2
A month in print
From this point on work on a copy of the original spreadsheet as we are making extensive formatting changes and these may need to be adjusted to suit the printer and paper you actually use. Before continuing use the File, Page Setup command to choose the paper type and orientation you intend to use and using the Printer button ensure it is sending output to the Printer of your choice if more than one is available.
A plain landscape display
For printing on letter or A4 in landscape orientation we first need to widen the columns. To do this select columns A to G using their heading labels, right-click the mouse, click on Column Width and type 20 into the box that opens.
Now select rows 7 to 12, right-click the mouse, click on Row Height and type 70 into the box that opens. Also select rows 5 to 6 and set their row height to 25.
Now add borders. First select the whole calendar grid plus headings, i.e. A5:G12, right-click, select Format Cells and click on the Border tab. Click on both Outline and Inside, choose the thick solid line in the Style box and click on OK.
To give space to write appointments in each box we'll place the numbers at the top left of the cells. Select A7:G12 and re-open the Format Cells dialog box and go to the Alignment section. Choose Left (Indent) from the drop down list of Horizontal options and Top from the drop down list of Vertical options then click OK:
To improve the presentation use the same method to align the day name in A6:G6 using Center for both Horizontal and Vertical.
Now choose the range A5:G12 and from the File menu click Print Area and choose Set Print area:
The area to be printed is then delineated and you can proceed to click the Print Preview button.
Before printing go to the Margins tab in the Page Setup dialog and adjust the margins as you require and place ticks in both the Horizontal and Vertical boxes in the Center on Page section:
If you discover that the document is going to print over more than one page use the Fit to button in the Page Tab of the page Setup dialog:
Add an illustration
If you want a portrait layout there is also space for a drawing or a photo. Again working on a copy of the original spreadsheet, first change the column widths and row heights as above, this time using 12 as the width and 40 as the height for the calendar grid. Next use the Format cells dialog and make selections to in the Alignment tab to control the placement of the numbers in the grid and add the grid lines using the Border section.
To make the space for the illustration inserting 2 rows after row 5. Merge both of them across columns A to G and set the row height of row 6 to 400. Then select A6, right-click, choose Format Cells and use the Border tab and the Outline preset to draw a frame. The empty frame could be used for drawing on or pasting in a photo:
If you prefer to insert some existing Clip Art or photo stored on the computer, place the cursor in A6 and use the command Insert,Picture and choose Clip Art or Photo as appropriate and then navigate to the item you want.
The picture initially inserted is likely to be far too big. To deal with it use the View menu to open the Picture Toolbar and use the Size option in the Format Picture dialog to get an approximate size.
Here we set the height to 12cm and then adjusted its size and position interactively with the picture's handles.
The steps for printing are the same as for the plain calendar above.
Find more spreadsheets
Moving to Excel 2010
Moving from an earlier version of Excel to the latest one can come as a culture shock. Here's an exploration of the differences and some new features.