How to Create a Daily Schedule in Microsoft

by Contributor

Making a daily schedule--a compilation of list of small tasks and their expected durations for completion--can help you live an organized and balanced life. Microsoft Office has various programs, including Microsoft Excel or Word, that make it easy to create daily schedules. (Making a schedule in Excel is simpler.) You can either download a free online template for a daily schedule or you can build a basic template.


Pick a start time and an end time for the daily schedule. Choose the time format that you'll be using. Microsoft Excel supports both 12-hour and 24-hour clock formats.


Select the time increment, say one hour. Decide this on the basis of the number and size of tasks you wish to complete in a day.


Select a cell and type the start time. Select the cell below this and now type the time with an increment. If start time is 9:00 a.m., for example, type “9:00” in the first cell. Type “10.00” in the next cell, if the increment is one hour.


Right-click on these first two filled cells after highlighting them. Select “Format Cells” from the pop-up menu. Choose the “Number” tab and click on “Time” for the “Categories” column. Choose the “Types” column and select the required format. Press “OK” to close.


Copy these two highlighted cells by pressing “Control + C.” Move down the column and keep pasting them by pressing “Control + V.” The same increment will be maintained in each cell as they are pasted.


Type events for each time slot in the adjacent cells. Keep the events concise and give adequate time to each depending on the size of the task.


Add borders around the schedule using the page layout option. Highlight important events and time slots using different colors.


  • check Customized templates can be directly downloaded from Microsoft Office online through Microsoft Excel. These daily schedule templates can then be edited per your needs.
  • check Add time slots for meals as well as short breaks spaced regularly within the whole day to make the schedule more practical and realistic.

More Articles

Photo Credits

  • photo_camera BananaStock/BananaStock/Getty Images