Creating a YEAR calendar with numbers
Hi,
anyone created a year calendar with the template?
I do not know how to change the months
thanks,
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.
Hi,
anyone created a year calendar with the template?
I do not know how to change the months
thanks,
stfflspl wrote:
SG, great calendar.
I would like to see the weeks starting on Monday (= the first day of the week), rather than on Sunday (the last day of the week).
Hi Paul,
In each of the month tables you can do this:
SG
Highly recommend visiting Numbers > Numbers Help in your menu.
SG
I've taken the template and derived a yearly calendar. You can download it here (Dropbox download).
I looks something like this.
Just go to File > Advanced > Language & Region ... to switch languages.
As with the original template there are hidden rows in the table that displays the year. Unhide those rows if you want to examine the inner workings.
Also note that this, and the original template, make use of Conditional Highlighting.
SG
Hi aum,
"I'm a beginner..."
We were all 'beginners' at several things at one point.
"I meant that "Unhide those rows if you want to examine the inner workings.", would be difficult for me, perhaps."
And perhaps it would be.
Start small.
Open the Calendar template as a new "untitled" document.
Take the mouse and explore. Click on a variety of the items that are on the screen. Note what you see when you click on each item.
The month name, for example, shows this when it is selected:
The reference tabs above and to the left of the month name and the year (this is from the template in Numbers 3, released a few years ago) show that the month and year are displayed on a single column, two row table.
The tab to the right of September shows that cell A1 is a popup menu cell. Clicking it opens a list of all 12 months.
Is A2 also a popup menu cell? A second click, on the cell, will tell you that.
Does this small table have any hidden rows or columns?
A trip to the Table menu shows a hint that it has both. "Unhide all rows" (selected) and "Unhide all Columns" are both displayed in black (not grey, like "Delete column", which Numbers won't le you do when only one column is visible).
Lots of other things to explore in this and other templates. It doesn't have to be done all at once—you can open a new copy of the Calendar at any time to take a look at the other features available, and there's no need to save the resulting document until you have started a document that you want to keep.
Take your time, and return here when you have further questions.
Regards,
Barry
SG,
I did try to change your calendar, modifying cell Month and Year::A5 from 1 (Sundays) to 2 (Mondays).
And adapted all tables accordingly, deleting column A and adding the column for the Sundays.
This is the result:
If you are interested in this approach, just tell me how to upload the document.
Paul.
hey!
thanks a Lot for sharing!
"As with the original template there are hidden rows in the table that displays the year. Unhide those rows if you want to examine the inner workings.
Also note that this, and the original template, make use of Conditional Highlighting."
Eventually it is out of my reach😅
I'm a beginner...
Thank you!
aumfromkmpro wrote:
Eventually it is out of my reach😅
I'm a beginner...
Did you try it? All you have to do is select a year (click the year and choose from the Pop-Up Menu) and Numbers does the rest. There's no need to study the inner workings if you don't want to.
SG
SG, great calendar.
I would like to see the weeks starting on Monday (= the first day of the week), rather than on Sunday (the last day of the week).
What is the best way to modify your template?
Many thanks in advance.
Paul.
thanks!
Yes! I did!
it is super easy. Now I got 2019 and 2020.
I meant that "Unhide those rows if you want to examine the inner workings.", would be difficult for me, perhaps.
Thank you!
"modifying cell Month and Year::A5 from 1 (Sundays) to 2 (Mondays)"
how?
Thanks
some technical English classes would also be fine 😄
Creating a YEAR calendar with numbers