Or, you can use formulas similar to those used for the holidays so that your list of birthday and anniversaries will automatically update when you change the year.įollow the instructions at the top of the Events worksheet when adding your own events. You can enter descriptions and dates the simple way by just typing them into the list in the Events worksheet. Save a backup copy of the template prior to customizing the calendar so that can start again the following year with all the formulas intact. However, after you manually edit the calendars, you shouldn't change the year or start month. When you manually enter text, you will be overwriting the formulas within the calendar, but that is okay. All of the cells in the calendar contain formulas, however, you can still manually edit the calendar to list events, highlight cells, merge cells across multiple days, etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |