You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hello, is there a way to create a cell in each month on the template that does not repeat itself. That way I could create a different topic such as health for january, and exercise for february.
Also, is there a way to stop cells repeating in each month? When I write a note on January 1st, it is repeated in every month for the rest of the year.
Thank you for your help
Hi Wes,
What version of Numbers? (Numbers menu > About Numbers)
What version of OS X/mac OS? (Apple menu > About this Mac)
Looking at the Calendar template in Numbers 3.6.2, it appears you create a new month by duplicating the Sheet containing the supplied calendar table (or by duplicating the "Blank" sheet, containing an empty calendar table), then choosing the new month from the pop-up menu in cell A1, at the top left corner.
Duplicating the Sheet where you have already entered one or more events does exactly what you should expect—it makes a copy of the Sheet, the four tables on the Sheet, and all of the formulas and contents of those four tables.
Simple solution: Start with the document as produced from the template, with nothing entered into the cells of the Monthly sheet's main table.
Duplicate that sheet as many times as you will need, then Rename the sheets to match the months (in order), and set the Month name and year in the two cells of the top left table. After setting the Month and Year, that table (and the two small tables showing month befor and month after) should be locked.
With the month and the year set, and the three subsiduary tables locked, you may want to save a copy of the document (as a Template) to use in the following year. With that done, you are ready to start making entries on the main Calendar table.
At the end of the year, close that year's calendar, open and set up a new one from the Template Chooser, and carry on.
NOTE: Don't bother making entries that repeat on the same date each month or on the same date each year before duplicating the sheets. The events will be included in the duplicate, but they will be placed in the same cell of the duplicate table, not in the cell for the same date in the next month or in the cell for the same date in the same month of the next year of the duplicated document.
Before going too far with creating a calendar document in Numbers, become familiar with the capabilities of the Calendar application included in the software bundled with your Mac. It can handle events that repeat on the same date each month or each year, and can also send you a message or an email reminding you of an upcoming event.
Regards,
Barry
Hi Wes,
What version of Numbers? (Numbers menu > About Numbers)
What version of OS X/mac OS? (Apple menu > About this Mac)
Looking at the Calendar template in Numbers 3.6.2, it appears you create a new month by duplicating the Sheet containing the supplied calendar table (or by duplicating the "Blank" sheet, containing an empty calendar table), then choosing the new month from the pop-up menu in cell A1, at the top left corner.
Duplicating the Sheet where you have already entered one or more events does exactly what you should expect—it makes a copy of the Sheet, the four tables on the Sheet, and all of the formulas and contents of those four tables.
Simple solution: Start with the document as produced from the template, with nothing entered into the cells of the Monthly sheet's main table.
Duplicate that sheet as many times as you will need, then Rename the sheets to match the months (in order), and set the Month name and year in the two cells of the top left table. After setting the Month and Year, that table (and the two small tables showing month befor and month after) should be locked.
With the month and the year set, and the three subsiduary tables locked, you may want to save a copy of the document (as a Template) to use in the following year. With that done, you are ready to start making entries on the main Calendar table.
At the end of the year, close that year's calendar, open and set up a new one from the Template Chooser, and carry on.
NOTE: Don't bother making entries that repeat on the same date each month or on the same date each year before duplicating the sheets. The events will be included in the duplicate, but they will be placed in the same cell of the duplicate table, not in the cell for the same date in the next month or in the cell for the same date in the same month of the next year of the duplicated document.
Before going too far with creating a calendar document in Numbers, become familiar with the capabilities of the Calendar application included in the software bundled with your Mac. It can handle events that repeat on the same date each month or each year, and can also send you a message or an email reminding you of an upcoming event.
Regards,
Barry
Hi Wes,
The Calendar template in Numbers has lots going on "behind the curtain" but you can raise the curtain and see what is going on.
Click on each table in turn and Format Panel > Table > click on Table Name.
Click on the Month and Year table (top left and Menu > Table > Unhide All Rows to see some very clever formulas.
The Calendar table changes by month and year, but only the even numbered rows (2, 4, 6...) to insert the correct day of the month.
The odd numbered rows (3, 5, 7...) do not change; they repeat whatever text they contain. That is why a note repeats every month.
Barry has hit the nail on the head. That template is designed such that you duplicate the "Monthly" Sheet (Tab) 11 times and select another month. Rename the tabs as January, February...
That way, each Sheet has a clean Calendar table to receive notes for that month.
Have a browse around each table and cell to see the formulas.
Regards,
Ian.
P.S. there was a discussion on this some time ago. I will search for it. I think that the conclusion was that the Calendar Template was created by a very clever person, and whilst it seems complicated, it is an excellent example of the Charm of Numbers. Ian.
Late Edit: Hi Wes and Barry,
Calender template in Numbers, start the week with Monday
The "nuts and bolts" of the Calendar Template.
Thanks to t quinn and SGIII
Ian.
Thank you for your help Yellowbox. Thats great!
Thanks Barry, that makes sense. Now I know it is used to duplicate and make your own calendar it makes a lot more sense. Cheers
Numbers calendar template
