Tnhelearning.edu.vn - Various useful general information portal

How to Create a Calendar on Microsoft Excel

by Category: How To

You are viewing the article How to Create a Calendar on Microsoft Excel  at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.

While Excel isn’t exactly a calendar program, you can use it to create and manage your calendars. Instead of customizing your own calendar, it’s much faster to use the various built-in calendar templates and customize to your liking. You can also import event lists from spreadsheets into Outlook calendars.

Use Excel templates

Image titled Create a Calendar in Microsoft Excel Step 1

Image titled Create a Calendar in Microsoft Excel Step 1

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e1/Create-a-Calendar-in-Microsoft-Excel-Step-1-Version-3.jpg/v4-728px- Create-a-Calendar-in-Microsoft-Excel-Step-1-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e1/Create-a- Calendar-in-Microsoft-Excel-Step-1-Version-3.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-1-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Start the Excel document. Click the “File” tab or the Office button and select “New”, a variety of templates will appear for you to choose from.

  • On certain versions of Excel, such as Excel 2011 for Mac, you’ll need to select “New from Template” in the File menu instead of “New”.
  • When you create a calendar from a template, you’ll have a blank calendar to populate with events. If you want to transfer a list of Excel data to your Outlook calendar, see the next section.
Image titled Create a Calendar in Microsoft Excel Step 2

Image titled Create a Calendar in Microsoft Excel Step 2

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/65/Create-a-Calendar-in-Microsoft-Excel-Step-2-Version-3.jpg/v4-728px- Create-a-Calendar-in-Microsoft-Excel-Step-2-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/65/Create-a- Calendar-in-Microsoft-Excel-Step-2-Version-3.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-2-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Find a calendar template. Depending on the version of Office you’re using, there may be a “Calendars” section, or you can simply type “calendar” in the search field. Some versions of Excel will display pre-selected calendar templates on the main page. If these templates fit your criteria, you can use them right away, otherwise you can find and choose from the calendar templates available online. [1]

  • You can search for more specific keywords depending on your needs. For example, if you need a class schedule, you can search for the keyword “academic calendar”.
READ More:   How to Grow and Care for Bonsai
Image titled Create a Calendar in Microsoft Excel Step 3

Image titled Create a Calendar in Microsoft Excel Step 3

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e1/Create-a-Calendar-in-Microsoft-Excel-Step-3-Version-3.jpg/v4-728px- Create-a-Calendar-in-Microsoft-Excel-Step-3-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e1/Create-a- Calendar-in-Microsoft-Excel-Step-3-Version-3.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-3-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Set the correct date on the template. After the template is loaded, a new blank calendar will appear. If the date is incorrect, you can change it using the menu that appears when you select the date.

  • The process may vary slightly depending on the template you use. Usually you can select the month or year to display and then click the ▼ icon that appears next to the time. The available options will appear, and the calendar will automatically adjust.
  • You can also set the start of the week by clicking on it and choosing a new date.
Image titled Create a Calendar in Microsoft Excel Step 4

Image titled Create a Calendar in Microsoft Excel Step 4

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/58/Create-a-Calendar-in-Microsoft-Excel-Step-4-Version-3.jpg/v4-728px- Create-a-Calendar-in-Microsoft-Excel-Step-4-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/58/Create-a- Calendar-in-Microsoft-Excel-Step-4-Version-3.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-4-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
See tips. Many templates will have a box with tips that will show you how to change the date or adjust other settings for the calendar template. You will need to delete these frames if you do not want them to appear in the printed calendar.
Image titled Create a Calendar in Microsoft Excel Step 5

Image titled Create a Calendar in Microsoft Excel Step 5

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e3/Create-a-Calendar-in-Microsoft-Excel-Step-5-Version-3.jpg/v4-728px- Create-a-Calendar-in-Microsoft-Excel-Step-5-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e3/Create-a- Calendar-in-Microsoft-Excel-Step-5-Version-3.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-5-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Adjust any bonded detail you want. You can adjust any element by selecting and making changes in the Home tab. Like any object in Excel, you can change its font, color, size, and more.
Image titled Create a Calendar in Microsoft Excel Step 6

Image titled Create a Calendar in Microsoft Excel Step 6

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/84/Create-a-Calendar-in-Microsoft-Excel-Step-6-Version-3.jpg/v4-728px- Create-a-Calendar-in-Microsoft-Excel-Step-6-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/84/Create-a- Calendar-in-Microsoft-Excel-Step-6-Version-3.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-6-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter events. Once the calendar is properly configured, you can start importing events and information. Select the cell where you want to add the event and then enter the data. If you need to add more than one piece of content on the same day, you can get creative with spacing.

Import Excel lists into Outlook Calendar

Image titled Create a Calendar in Microsoft Excel Step 7

Image titled Create a Calendar in Microsoft Excel Step 7

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d1/Create-a-Calendar-in-Microsoft-Excel-Step-7-Version-3.jpg/v4-728px- Create-a-Calendar-in-Microsoft-Excel-Step-7-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d1/Create-a- Calendar-in-Microsoft-Excel-Step-7-Version-3.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-7-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Create a new spreadsheet in Excel. You can import data from Excel into your Outlook calendar. This will make it easier to enter data such as work schedules.
Image titled Create a Calendar in Microsoft Excel Step 8

READ More:   How to Get Rid of Centipedes

Image titled Create a Calendar in Microsoft Excel Step 8

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c7/Create-a-Calendar-in-Microsoft-Excel-Step-8-Version-3.jpg/v4-728px- Create-a-Calendar-in-Microsoft-Excel-Step-8-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c7/Create-a- Calendar-in-Microsoft-Excel-Step-8-Version-3.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-8-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Add the appropriate title to the spreadsheet. It will be easier for you to import your list into Outlook if the spreadsheet is formatted with appropriate headings. Enter the following headings in the first line:

  • Subject (Subject)
  • Start Date
  • Start Time
  • End Date
  • End Time
  • Description (Description)
  • Location (Location)
Image titled Create a Calendar in Microsoft Excel Step 9

Image titled Create a Calendar in Microsoft Excel Step 9

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/14/Create-a-Calendar-in-Microsoft-Excel-Step-9-Version-3.jpg/v4-728px- Create-a-Calendar-in-Microsoft-Excel-Step-9-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/14/Create-a- Calendar-in-Microsoft-Excel-Step-9-Version-3.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-9-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter each calendar entry on a new line. The “Subject” field is the name of the event that will appear on the calendar. You don’t have to enter the entire title above in each field, but you should at least have “Start Date” and “Subject.”

  • You need to enter the date in the standard format MM/DD/YY or DD/MM/YY for Outlook to understand.
  • You can create multi-day events using the “Start Date” and “End Date” fields.
Image titled Create a Calendar in Microsoft Excel Step 10

Image titled Create a Calendar in Microsoft Excel Step 10

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6b/Create-a-Calendar-in-Microsoft-Excel-Step-10-Version-3.jpg/v4-728px- Create-a-Calendar-in-Microsoft-Excel-Step-10-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6b/Create-a- Calendar-in-Microsoft-Excel-Step-10-Version-3.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-10-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open the “Save As” menu. After you add an event to the list, save a copy of the list in a format that Outlook can read.
Image titled Create a Calendar in Microsoft Excel Step 11

Image titled Create a Calendar in Microsoft Excel Step 11

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/81/Create-a-Calendar-in-Microsoft-Excel-Step-11-Version-3.jpg/v4-728px- Create-a-Calendar-in-Microsoft-Excel-Step-11-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/81/Create-a- Calendar-in-Microsoft-Excel-Step-11-Version-3.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-11-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select “CSV (Comma delimited)” from the file type menu. This is a common format that can be imported into many different programs including Outlook.
Image titled Create a Calendar in Microsoft Excel Step 12

Image titled Create a Calendar in Microsoft Excel Step 12

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/62/Create-a-Calendar-in-Microsoft-Excel-Step-12-Version-3.jpg/v4-728px- Create-a-Calendar-in-Microsoft-Excel-Step-12-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/62/Create-a- Calendar-in-Microsoft-Excel-Step-12-Version-3.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-12-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Save file. Name the list and save the file in CSV format. Click “Yes” when Excel asks if you want to continue.
Image titled Create a Calendar in Microsoft Excel Step 13

Image titled Create a Calendar in Microsoft Excel Step 13

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/95/Create-a-Calendar-in-Microsoft-Excel-Step-13.jpg/v4-728px-Create-a- Calendar-in-Microsoft-Excel-Step-13.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/95/Create-a-Calendar-in-Microsoft-Excel- Step-13.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-13.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open your Outlook calendar. Outlook is part of the Office toolkit and is usually pre-installed if you already have Excel. When Outlook opens, click the “Calendar” button in the lower left corner to view the calendar.
Image titled Create a Calendar in Microsoft Excel Step 14

Image titled Create a Calendar in Microsoft Excel Step 14

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/30/Create-a-Calendar-in-Microsoft-Excel-Step-14.jpg/v4-728px-Create-a- Calendar-in-Microsoft-Excel-Step-14.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/30/Create-a-Calendar-in-Microsoft-Excel- Step-14.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-14.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the “File” tab and select “Open & Export”. You will see many options for data processing in Outlook.
Image titled Create a Calendar in Microsoft Excel Step 15

READ More:   How to Make a Smoking Pipe from an Apple

Image titled Create a Calendar in Microsoft Excel Step 15

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f2/Create-a-Calendar-in-Microsoft-Excel-Step-15.jpg/v4-728px-Create-a- Calendar-in-Microsoft-Excel-Step-15.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f2/Create-a-Calendar-in-Microsoft-Excel- Step-15.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-15.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select “Import/Export”. A new window for importing and exporting data on Outlook will appear.
Image titled Create a Calendar in Microsoft Excel Step 16

Image titled Create a Calendar in Microsoft Excel Step 16

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/84/Create-a-Calendar-in-Microsoft-Excel-Step-16.jpg/v4-728px-Create-a- Calendar-in-Microsoft-Excel-Step-16.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/84/Create-a-Calendar-in-Microsoft-Excel- Step-16.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-16.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select “Import from another program or file” and then click “Comma Separated Values”. You will be prompted to select the file you want to load.
Image titled Create a Calendar in Microsoft Excel Step 17

Image titled Create a Calendar in Microsoft Excel Step 17

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c1/Create-a-Calendar-in-Microsoft-Excel-Step-17.jpg/v4-728px-Create-a- Calendar-in-Microsoft-Excel-Step-17.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c1/Create-a-Calendar-in-Microsoft-Excel- Step-17.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-17.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click “Browse” and find the CSV file you created in Excel. Usually the file is in the Documents folder if you don’t change the default save location in Excel.
Image titled Create a Calendar in Microsoft Excel Step 18

Image titled Create a Calendar in Microsoft Excel Step 18

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6b/Create-a-Calendar-in-Microsoft-Excel-Step-18.jpg/v4-728px-Create-a- Calendar-in-Microsoft-Excel-Step-18.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6b/Create-a-Calendar-in-Microsoft-Excel- Step-18.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-18.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
You need to check that “Calendar” is selected as the destination folder. Since you’re in Outlook’s calendar view, “Calendar” will be selected.
  • Image titled Create a Calendar in Microsoft Excel Step 19

    Image titled Create a Calendar in Microsoft Excel Step 19

    {“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/17/Create-a-Calendar-in-Microsoft-Excel-Step-19.jpg/v4-728px-Create-a- Calendar-in-Microsoft-Excel-Step-19.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/17/Create-a-Calendar-in-Microsoft-Excel- Step-19.jpg/v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-19.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
    Click “Finish” to import the file. After the program processes the list, the events are added to the Outlook calendar. You can find the event in the location that matches the time set by the list. If you include a description, it will appear when the event is selected. [2]

    • While Excel isn’t exactly a calendar program, you can use it to create and manage your calendars. Instead of customizing your own calendar, it’s much faster to use the various built-in calendar templates and customize to your liking. You can also import event lists from spreadsheets into Outlook calendars.

    Thank you for reading this post How to Create a Calendar on Microsoft Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.

    Related Search:

    Related Posts

    How to Create Curved Text in Photoshop
    How to fall asleep faster
    How to Install FBReader to Read eBooks