How to Create a Month Calendar in Excel - Tutorial 📆
ฝัง
- เผยแพร่เมื่อ 11 ก.ย. 2024
- Excel tutorial to learn how to create a calendar in Excel. We’ll make a month calendar in Excel that you can recreate for any month, for any year. We’ll create the calendar so that it’s fillable and printable.
To learn how to format a calendar in Excel and also create a marker for the current day using conditional formatting, make sure to watch my follow-up video tutorial -
How to Format an Excel Calendar - Tutorial: • How to Format a Calend...
and
To learn how to add a background picture that you can print to your calendar, watch this short tutorial -
How to Add a Printable Background Picture in Excel - Tutorial: • How to Add a Printable...
If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: yacostasolutio...
*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: yacostasolutio...
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: yacostasolutio...
Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends - it really helps us out 😊
To catch our Excel tutorials as they come out, subscribe to this channel by clicking: yacostasolutio...
Thanks!
*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!
#YAcostaTutorials
![[[OFFICIAL MV]] เอิ้นขวัญให้อ้าย- อ๊ะอาย สกุณาพร | ค่ายเพลงเป็นหนึ่ง](http://i.ytimg.com/vi/83x6L3X3qh0/mqdefault.jpg)
Excellent tutorial! Would you please show how to format a side by side (horizontally) calendar? For my job I need to see Jan next to Feb, March next to April, etc. I struggle at formatting because it's been over 10 years since my classes in Excel. I don't use it much at work and have forgotten almost everything!
thanks ! this help me a lot.
That's great! Glad it helped. Thanks so much 🙂
Great tutorial!
Thanks, Megan. I’m happy you liked this 🙂
THANKS IT IS VERY HELPFUL
Thank you! I'm so happy this helped you 🙂
Well done, thank you I was able to do so in excel on my Google drive
That's great!! Google Sheets is a great alternative to Excel. Happy that it worked for you and thanks for sharing your success 🙂
Super helpful. Thanks so much
Hi, Keme. I'm happy you found this helpful! Thank you for sharing 🙂
Great video ❤ New subbie here 👋
Awesome! Happy this helped you and welcome to the group 🙂
This was an amazing how to video thanks!
Thanks so much, Kimberly 🙂 Glad you enjoyed it!
tHANK YOU!!!
Thank you, Rebecca. I’m happy you liked this 🙂
Thank this vdo is help my homework
I hope you got good marks on it. Thanks!
it's very use full video. i like this.
Thank you, Tarek. I'm happy you found it helpful 🙂
Thank you for the video :) It is very helpful.
Thank you, Anupama! Happy you found it helpful 🙂
This was helpful thanks alot
Thank you, Jola! I’m happy you found it helpful and thank you for sharing 🙂
I am really confused on how you are copying it down to the end of the row when you are referring to the days. I am really green with excel.
Hi, Rev. Sorry this was confusing! I hope these explanations help:
When I filled in the names of the days, I typed Sunday and then dragged that across the row to fill the other days. I dragged by using my left mouse button to grab the bottom-right corner of the cell. Then, still holding my left-mouse button down, dragged it to the next 6 cells.
I was able to do this because the days of the week can be autofilled in Excel. Autofill lists are lists of items that commonly follow the same order (days, months).
These can be stored within Excel. Some are built-in, but you can also add your own lists.
Then, when you type an item on the list, you can drag to neighboring cells and auto filI them with that list. I have a tutorial on Autofill that might help: th-cam.com/video/fjc2-QzW5fI/w-d-xo.html
When I copied and pasted the date number, I did it by using the Ctrl+C keyboard shortcut to copy a cell and then Ctrl+V to paste it to other cells.
I hope this helps. Please let me know if you have more questions. Thanks!
Great tutorial. Thank you
Thank you! Happy you enjoyed it 🙂
thank you
Thank you, Tony. I'm happy you liked this 🙂
Love Your Tutorial! 👌 I'm hoping you will be able to help me create a one-month page, 6 x 9, with Year, Month and Days Blank to be filled in after being printed..
(6 Weeks. 7 days). I also need to fill in each day with the same information, leaving the last four spaces at the end of the month to add Clip Art Pictures... I hope I have been detailed enough with this request... Thanking you in advance. 🤗 Stay Blessed. 🙏
you didnt show the steps how youve done all the boxes i just have made the boxes on top but i dont know now how to put it on the bottom.
she skipped a lot of steps. it was almost as if she made the video for herself and not to teach others.
Like this tutorial? Make sure to grab your FREE pdf list of top Excel keyboard shortcuts: yacostasolutions.com/newsletter/
nice video.. madam ur voice like as leaila gharani
Thank you 🙂
Could you enter 10 or 8 names of birth day celebrants per day?
2:58 what did you do here I am really confused
Hi, Maanas. At that particular point I wasn't doing anything. I had Row 2 selected while I spoke. Once I restarted, I selected a total of 7 rows and set the height for all of them at the same time. Hope this answers your question. Thanks
How do I set the margins on my tablet because my tablet won't let me do it. do I need a laptop in order to change the margins because I have tried every way possible to try and change the margain sizes. its really frustrating. Can anyone help me please ?
It's not yet possible on mobile, unfortunately.
@@YAcostaSolutions Do you have any other suggestions on how I can create a month calendar in excel without the page layout tab ?
How can I remove Saturday and Sundays?
Hi, Edna. You can leave them off. Then, only on Mondays, instead of referencing the prior Sunday and adding 1, you would reference the prior Friday and add 2. Then, on Tuesday, Wed, etc, you would do +1 like we did in the tutorial. Hope this makes sense.
Also, you can make your days wider since you'll have 2 less 🙂
How to change cm to inch in page layout...
Hi, Tanusree. You can change this in your Excel Options. Once in your Excel Options, go to the Advanced section. Scroll to the Display section and select the measurement type you want to use from "Ruler Units."
If you like, I have an article with step by step instructions of how to do this (with pictures) on my website: yacostasolutions.com/measurement-units-excel/
I hope this helps. Please let me know if you have more questions. Thanks!
How did you magically fill up the boarders? Is frustrating me 🤦🏻♀️
Hi. I selected the area that would make up each day, then for each one, applied the "Outside Borders" option from the Home tab / Font section / Borders drop-down. It looks like magic because it was editing magic; I only did a few examples of adding the borders, then cut to the part with all the borders done. Sorry that threw you off, but hope this explanation helps. And thanks for stopping by 🙂
Hello Yacosta hOw can contact you?
madam ur name Leila .? xelplus channel
Hi, Vikas. Nope, that is not me. @Leila_Gharani has a different channel 🙂 You can find her channel at th-cam.com/channels/JtUOos_MwJa_Ewii-R3cJA.html
@@YAcostaSolutions 😊🤣
My calendar when absolutely mental when I tried to drag the column to fit the page. Keeps giving me a calendar that 50 meters wide.
Edit: God, now you've really lost me with the borders. Fck this. I wish Excel was a person so I could punch it in the face.
Who knew there was 28 days in February
🤔
Stephanie Coull lol..Everybody !!!
Expect me
Stephanie Coull it’s : *except.....lol..Yeah , I believe u now 😂😂🤔