monthly-calendar-template by jvsharma


									Monthly Calendar Help                                                        © 2007 Vertex42 LLC
Note: These instructions apply to Excel 2000/2002(XP)/2003
Also, if you are trying to figure out how the template works, you'll need to do two things:
1) Go to Insert > Names… > Define, and take note of the named ranges
2) Unhide the Settings sheet by going to Format > Sheet > Unhide …

Using the Calendar as a Template

            To add events to the calendar and use the spreadsheet for more than just one month,
            first make a copy of the current month and paste it into the Planning worksheet.

            1) Select the Calendar Range. This can be done quickly by pressing Ctrl+G
            and then selecting "calendarRange" from the list box.

            2) Copy the Whole Calendar. Press Ctrl+c or select Edit -> Copy

            3) Paste the Calendar into the Planning worksheet
                     The planning worksheet has been formatted so that the column widths
                     are the same as the Calendar worksheet.
                     a) Select cell A1 in the Planning worksheet
                     b) Press Ctrl+v or select Edit -> Paste

            4) Convert Formulas to Static Dates
                    Pasting the calendar will also paste the cell formulas, so …
                    Immediately after pasting the calendar …
                    a) Select Edit -> Paste Special …
                    b) Choose the "Values" option, and select OK

Copying the Calendar to a New Workbook

            The best way to copy your calendar to a separate workbook is to first copy your
            calendar to the Planning worksheet as mentioned above and then copy the Planning worksheet
            into a new workbook. This is done by right-clicking on the worksheet tab and selecting
            Move or Copy… as shown below. Make sure you COPY the worksheet and don't MOVE it.

            By repeating the process of copying the calendar to the Planning worksheet and then copying
            the worksheet to the new workbook, you can create a 12-month calendar in which you have each
            month on a different worksheet.
       Copying the Color Scheme
       When coping the sheet to a new workbook, the color scheme will change to that of the new
       workbook. In Excel 2000/2002(XP)/2003, this will be very obvious (the calendar will turn a
       hideous orange color. To update the colors in the new workbook, follow the directions below.

                   In the New Excel Workbook …
                   1) Go to Tools -> Options…
                   2) Choose the "Color" tab
                   3) In the "Copy colors from" field, choose this file (the excel calendar template).
                   Note: You can only copy colors from a file that is already open.

Copying the Mini Calendars

       To create copies of the previous and next month calendars as pictures, rather
       than linked objects, you will need to use a little "trick".
                         September 2004                      November 2004
                          S    M    T    W    Th   F    Sa    S   M    T    W    Th   F    Sa
                                         1    2    3    4         1    2    3    4    5    6
                          5    6    7    8    9    10   11    7   8    9    10   11   12   13
                          12   13   14   15   16   17   18   14   15   16   17   18   19   20
                          19   20   21   22   23   24   25   21   22   23   24   25   26   27
                          26   27   28   29   30             28   29   30

                   a) Select one or both of the calendars
                   b) Hold down the "Shift" key as you click on the Edit menu. This makes the option
                      "Copy Picture…" appear.
                   c) Choose the options you want, and select OK.
                   d) Paste (Ctrl+v) the image into Excel.


       Everything is already set up to print the calendar to letter size paper (landscape), but here
       are a few printing tips:

                   Fitting the Calendar to the Paper Size
                   a) Go to File -> Print Area -> Set Print Area …
                   b) Select the range of cells you want to print.
                   c) Go to File -> Page Setup
                   d) In the Page tab, select the "Fit To: …" option
                   e) Select print preview and change other options as needed.

Hiding / Showing Cell Gridlines

       To toggle the cell gridlines on and off in Excel, go to Tools -> Options -> View
       then check or uncheck the Gridlines option.

       If you find yourself doing this frequently, you can add a button to your toolbar
       that will toggle the gridlines on and off.
       1) Go to Tools -> Customize …
       2) In the Commands tab, choose the Forms category
       3) Scroll down the list of Commands until you see the Toggle Grid button
       4) Drag and drop the toggle grid button into one of your toolbars
      A convenient place for the grid button is next to the zoom dropdown box.

Modifying the Format/Color/Etc.

      The calendar uses CONDITIONAL FORMATTING to change the background color of the
      cells. To remove all conditional formatting, select all the cells in the calendar, then go to
      Format > Conditional Formatting …, then select Delete, then check all three boxes and
      select OK.

      If you with to modify the background color and keep the conditional formatting, the easiest
      way to do it is to modify the color in the color palette. This is done by going to
      Tools > Options… > Color Tab. The two colors used for the calendar are circled below.

      To quickly select just the cells containing the day of the month, press Ctrl+G and select
nning worksheet

d then copying
hich you have each
at of the new

ections below.

alendar template).

u. This makes the option
              SEPTEMBER 2010
     Monday        Tuesday    Wednesday                    Thursday            Friday            Saturday        Sunday
                             1                        2                   3                  4              5

6             7              8                        9                   10                11              12

13            14             15                       16                  17                18              19

20            21             22                       23                  24                25              26

27            28             29                       30

                                            August 2010               October 2010          Notes:
                                  M    T     W Th F Sa Su        M    TW Th F Sa       Su
                                                          1                    1   2   3
                                  2    3     4   5   6  7 8      4  5   6  7   8   9   10
                                  9    10    11 12 13 14 15      11 12 13 14 15 16     17
                                  16   17    18 19 20 21 22      18 19 20 21 22 23     24
                                  23   24    25 26 27 28 29      25 26 27 28 29 30     31
                                  30   31
(See "Using The Calendar as a Template" in the Help worksheet)

To top