Lompat ke konten Lompat ke sidebar Lompat ke footer

how to create a calendar of events in excel

In this article, you'll discover how to create a calendar in Excel with step-by-step instructions. We've also provided pre-built monthly and yearly calendar templates in Excel and PDF formats to save you time.

Enclosed on this foliate, you'll find how to make a yearly calendar in Excel, how to tailor-make your calendar in Excel, and how to put in a calendar into Excel.

How would you alike to create your calendar?

Expend a pre-reinforced calendar templet in Smartsheet

Time to rank: 3 minutes

- or -

Manually create a calendar in Excel

Time to realised: 30 minutes

Smartshee

Excel Calendar Template

Download a Monthly or Yearly Calendar Excel Template

2022 Printable Monthly Calendar Landscape Template

Download 2022 Monthly Calendar Template (Landscape)

Surpass | PDF

2022 Printable Monthly Calendar Portrait Template

Download 2022 Unit of time Calendar Template (Portrait)

Excel | PDF

2022 Annual Calendar Template

Download 2022 Full-Yr Calendar Stand out Template

See how Smartsheet can help you cost more effective

Watch the demo to see how you can more effectively manage your team, projects, and processes with factual-time solve management in Smartsheet.

Watch a free demo

How to Use of goods and services a Monthly Beaver State Yearly Calendar Excel Templet

Victimisation a calendar template is incredibly easy. Every you need to do is choose whether you need a monthly or yearly calendar, and add your regular events to the guide. You can besides customize the face types, font sizes, and colors. If you choose the monthly calendar, you will first need to convert the title and the dates for the specific month you want to use.

Here are more steps for customizing your template for your inevitably.

1. Formatting the Monthly Calendar Template

  1. To shift the title of respect, double-click on the title field, delete the formula, and eccentric the current month.
  2. Then, you will require to re-number the date fields. You can either manually enter the dates, or use the auto-fill feature article mentioned in step iv of the "How to Make a Monthly Calendar in Surpass 2003, 2007 and 2010" section.

2. Adding Events to the Monthly or Yearly Calendar Templet

  1. In either template, double-click on a cell in a date box and infix the event. To enter multiple events on the same day, chatter connected another cell in the date box.
  2. To center the text, click on the cell. Then, in the Home tab, in theAlignment group, click the Center Textbook icon (information technology looks wish five lines of text that are centred).

Add an Event - Calendar in Excel

Changing Fonts and Colours

  1. Click on the cell with the text you'd like to modify, and in the Dwelling house tab, you canful alteration the font type, font size, baptistry color, operating theatre make the text bold, italicized, or underlined.
  2. To change the background color of the weekday lintel or of an event entry, highlight the cell, pawl the paint bucket icon, and select the fill people of color.

You can also personalize your calendar template by adding a photo, like your company logotype. In theInsert tabloid, clickPictures.Upload the picture you would the likes of to use. The image testament atomic number 4 added to your spreadsheet and you can drag it anywhere in the mainsheet.

How to Make a Monthly Calendar in Excel 2003, 2007 and 2010

Here are some step-by-step instructions for devising a monthly or yearbook calendar in Excel.

1. Add Weekday Headers

Outset, you'll need to add the days of the hebdomad arsenic headers, As advantageously as the month title.

  1. Leave the first dustup in your spreadsheet blank. On the second row, type in the days of the workweek (unrivaled day per cell).
  2. To format the weekday headers and ensure proper spacing, highlight the weekdays you just typed and on the Home tab, in the Cells grouping, click Formatting.  Select Column Width and dictated the width for around 15-20, contingent how wide you want the calendar.

Calendar in Excel

2. Add Calendar Deed of conveyance

  1. In the first blank row, we will add the current month as the title of the calendar using a formula. Click some cell in the first row and in the fx bailiwick above the blank course, enter =TODAY(). This tells Excel you want today's date in that field.

Excel calendar

  1. You'll see the initialize of the date is mistaken. To fix this, snap the cell with the date. In the Home tablet, in the Bi group, click the Date overlook-down. Select More Number Formats and prefer the format you would like for the calendar month statute title.
  2. To center the title, highlight all the cells in your title quarrel (including the one with the month displayed) and click on the Merge and Center button in the Home tab.

Merge Center - Calendar in Excel

3. Create the Days in the Calendar

Hither is where you will build the body of your calendar. We will use borders to create the date boxes.

  1. First, high spot your whole spreadsheet.
  2. Click the paint bucket icon in the Home tab and select white. Your spreadsheet should now cause a white background.

  1. Then, foreground Phoebe or 6 cells low the first weekday header, Sunday.

Add Border - Calendar in Excel

  1. While the cells are still highlighted, click the borders icon in the Home tab and select the outside borders option. This will outline the initial date stamp box up the row.
  2. Highlight the box you just made, and copy and paste it under the other weekday headers. This duplicates your package for the other years in the week.
  3. Act this for five total rows in your sheet. The calendar should look like this:

Blank No Dates Calendar in Excel

To add borders around the weekday headers, highlight the row with the weekdays, click the borders icon, and choose the all borders.

4. Bestow Dates

We've created the framework for the calendar, straightaway it's meter to add the dates. You rear end either manually come in the dates in to each one corner, or use Excel's machine-fill out sport. Here's how:

  1. For each row in the calendar, get into the first ii dates of that week in the first cells in each package. For example, if the 1st of the month is Wednesday, enter 1 into the eldest Wednesday box and 2 in the Th box.
  2. Then, hold down Careen and highlight both cells with the Book of Numbers.
  3. Drag the bottom right corner of the highlighted cells to machine-fill the rest of the week.
  4. Repeat for the whole month.

Blank Calendar in Excel


Note: You moldiness manually enter the first deuce dates for each row before you can drag and auto-fill the rest of the week.

How to Make a Each year Calendar in Stand out

You have essentially created a monthly calendar template. If you want to function a calendar solely on a month-by-month basis, you can function this same calendar, change the month title, and antitrust re-number the years.

You could as wel use this unit of time calendar framework to make a yearly calendar.

  1. On the bottom of the spreadsheet, right-click connected the tabloid that says Sheet1.
  2. Click Move or Copy.
  3. Select the box for Create a copy and click OK.

  1. Make a total of 12 copies, one for each month of the year. Greenbac: for months with 31 days, you volition need to add an extra row to the calendar.

In one case you have 12 copies, you will have to plump finished to each one one and commute the title to the appropriate month. You'll also have to Ra-number the calendar according to the ad hoc month, either manually changing the dates or victimisation the automobile-fill lineament mentioned in step four of the "How to Make a Monthly Calendar in Stand out 2003, 2007 and 2010" section.

Customize Your Calendar in Excel

It's easy to customize your monthly operating theatre time period calendar in Excel. You can color-cipher certain events on the calendar, like meetings or birthdays, OR modification fount sizes. You can even add your company logo to the calendar.

1. Format Fonts

  1. To make the title bigger, click the row with the title. In the Home tab, you can shift the font type, fount size, and make the title bold, italicized, or underlined.
  2. To change the face size of the weekday headers, highlight all the headers. In the Home tab, you can formatting the font typewrite and size.

Choosing Fonts - Calendar in Excel

  1. To format the date markers, highlight all the date boxes. In the Place tab, you can set the font type and size.

2. Modification Colors

You derriere change the font colours surgery the background colors in your calendar. Color-coding may be especially helpful for labeling certain types of events.

  1. To change the deed emblazon, click connected the row with the title. In the Home tab, blue-ribbon the colouration you want from the color overlook-pour down lean.
  2. To change the background color of your weekday heading, highlight the whole row,  penetrate the paint bucket ikon, and superior the fill color. You can also just change the schoolbook color aside repetition step one and only.
  3. To color code an event, type an upshot or designation into a date box. Then, select the text, sink in the blusher bucket icon, and select the fill colourise.

Choosing Colors - Calendar in Excel

3. Tote up a Photo

Personalize your calendar by adding images, ilk your company logo.

  1. In the Slip in yellow journalism, click Pictures. Upload the picture you would like to use.
  2. The image will be added to your spreadsheet and you can cart it anyplace in the tack.

Add Picture - Calendar in Excel

If you would like to add your logo or picture to the top of the calendar, you will cause to attention deficit disorder extra place indeed the image can fit.

  1. Right-click the first row, with your title, and select Insert.
  2. Click Entire Dustup.
  3. Repeat depending on how many extra rows you want.
  4. To have the background of the new rows white, highlight the new rows, click the paint bucketful ikon, and select white.
  5. To remove the grid line in a higher place the title words, select the title row, click the grid icon, and fall into place the option with the removed gridlines.

Print a Calendar in Excel

Your customized, formatted calendar can be a challenge to print. The sides of the calendar extend on the far side a printable page, so you volition end up with parts of a calendar printed on two pages. Here's how to fix it:

  1. In the Thomas Nelson Page Layout tab, click Orientation > Landscape painting.

Orientation - Calendar in Excel

  1. In the Scale to Meet radical, change the width to 1 page and the height to 1 page.

Immediately, your calendar will black and white connected one page.

How to Find a Microsoft Calendar Template

Microsoft has besides created a handful of calendar templates. You can opt from a multi-page calendar, a yearly calendar, a weekly calendar, and more.

Here's how to use a pre-made template available in Excel:

  1. Get through File > New.
  2. Character Calendar in the search field.
  3. You'll see a variety of options, but for this example, click the Any class one-month calendar and click Create.

Office 2016 Calendar

You'll see a put over on the right with Calendar Month, Civil year, and 1st Solar day of Week.

  1. Select the cellular telephone that says January and chink the pointer that appears. In the drop-down menu, superior the calendar month for your calendar.
  2. Enter the calendar year in the cell underneath the month.
  3. Select the cell that says Monday and click the arrow that appears. In the drop-down fare, select the first day of the month.

You terminate also bring down Microsoft's online template gallery away clicking here, and selecting the calendars category on the left-hand side.

How to Insert a Calendar with Visual Staple

You bum insert a pre-ready-made, pre-populated calendar directly into Stand out victimisation the CalendarMaker with the Optic BASIC Editor. You will call for to enable the Developer Mode in Excel, and usage a programming speech, but IT is simple to do and Microsoft offers a try code for you to use.

1. Enable Developer Mode

First, you'll need to ferment on the Developer Mode.

  1. Click File > Options.
  2. In the pop-up box seat, happening the left-hand side, come home Customise Ribbon.
  3. Low-level Primary Tabs, stimulate sure the Developer box is checked.

Developer ribbon in Excel

You will now see a new tabloid in your Excel ribbon at the top of the spreadsheet.

2. Insert the Calendar with the Optical Basic for Applications Code

Microsoft has a taste Visual Basic for Applications encipher here for you to use and create the calendar.

  1. Create a new workbook.
  2. In the Developer tab, click Visual Basic.
  3. You will see a list of workbooks and sheets (under VBAproject on the left side). Find the Sheet1 entry and replicate-click.
  4. A blank pop-upfield box will appear. Copy and paste the Visual Basic for Applications code (launch Hera) into the box.

Visual Basics

  1. In the File fare, click Close and return to Microsoft Excel.
  2. Recur to the Developer chit and clink Macros.
  3. Select Sheet1.CalendarMaker and chatter Function.
  4. In the pop-up box, type the brimful month and year you require for your calendar and click OK. Your calendar should look like this:

Smartsheet

How to Make a Calendar in Minutes with Smartsheet's Calendar Template

Try Smartsheet for Free

Smartsheet's pre-formatted templates allow you to instantly create a calendar. Months, days of the calendar week, and dates are pre-formatted, and you have elbow room to add descriptions, comments, and continuance in hours of each natural action.

Here's how to use a calendar template in Smartsheet:

1. Choose a Calendar Template

  1. Give-up the ghost to Smartsheet.com and log in to your calculate (or start a free 30-day run).
  2. From the Home screen, click + image and typeCalendar in the search exclude.
  3. You'll see a handful of results, but for this example, snap on Calendar by Day and click on the blue Wont button.

Calendar Solution Center Smartsheet

2. List Your Calendar Selective information

A pre-made template wish open, complete with the months and dates already formatted for the total year. There will also be sample content filled in for reference.

  1. Add your calendar events under the Activity column. You buttocks also add Thomas More point in the Description, Hours, and Comments columns.
  2. To add multiple events for the same date, you must create a untested row. Perpendicular-click on a quarrel and select Insert Row Supra or Enclose Row Below. And so, therein new row, contribute the month, day of the week, date, and activity.
  3. If you need to delete a row, right wing-click on the mobile phone in the row you'd the likes of to delete and select Delete Row.

Smartsheet Calendar in Grid View

On the leftish side of each row, you can attach files flat to a task or start a comment around a certain event, adding more circumstance to your calendar.

3. Change to Calendar View

All your calendar information lives in this put over. Then, with the click of a button, you can project all the data auto-populated into a calendar.

  1. On the toolbar, alternate to Calendar View.

You will now see all your info in a calendar (today's date will be outlined in blue). You can edit operating room tote up an event directly from this calendar view, operating theater variety the color of an event, by double-clicking on a blue house of cards.

Smartsheet Calendar View

Anything you convert in this calendar view will be mechanically updated in your table.

Ploughshare your calendar with colleagues, friends, or family. You can choose from impression, exportation, or emailing your calendar from Smartsheet.

To email your calendar:

  1. Above the toolbar, click File.
  2. Select Send as Fastening.
  3. In the To field, add the recipient(s). Choose from your contact list or type email addresses.
  4. The Subject and Message fields are motorcar-populated for you, but you can choose to delete the text and add your own.
  5. Pick out whether to attach the calendar as a PDF or Excel sheet, and whether you neediness to send the calendar at once or on a recurring footing.

Send Calendar as Attachment Smartsheet

To share your calendar with a link:

  1. On the toolbar, click on the calendar picture.
  2. Select the publishing option you would like by clicking the slider.
  3. A pop-up box leave appear with a write link. You can copy and paste the link for anyone to view the calendar or use the implant code to embed the calendar into any webpage.

Publish Smartsheet Calendar

To print your calendar:

  1. On the toolbar, click the printer icon.
  2. Choose the calendar date range, theme size, orientation, and more. Then, click OK.
  3. A PDF version of your calendar will get down downloading. You can so black and white this PDF.

Learn more some working in Smartsheet's energetic calendar view and get weaving today.

Improve Preparation Efforts with Real-Time Work Management in Smartsheet

From simple task management and see planning to complex imagination and portfolio management, Smartsheet helps you meliorate coaction and addition work velocity -- empowering you to get more done.

The Smartsheet platform makes it easy to plan, captivate, manage, and report card on work from anywhere, portion your team be more potent and pay off more done. Report connected key prosody and get real-time visibility into go as it happens with pealing-up reports, dashboards, and automated workflows built to sustain your team connected and informed.

When teams have clarity into the work acquiring done, there's no informatory how so much more they can accomplish in the cookie-cutter amount of money of time. Render Smartsheet for free, today.

how to create a calendar of events in excel

Source: https://www.smartsheet.com/easiest-way-make-calendar-excel

Posting Komentar untuk "how to create a calendar of events in excel"