How to Make a Schedule in Excel

Plan days, weeks, or months in a worksheet

Learn how to make a schedule in Excel

Marek Levák/Unsplash

Whether you need to make a class schedule or a schedule for work or family, you can do it in Microsoft Excel using a template or from scratch. Microsoft Excel, provides templates for a weekly chore schedule, a student schedule, a daily work schedule, and many more. You can download the one you want and customize it with your own data, or, if you want to make something more specific, you can learn how to create a schedule in Excel from scratch.

Instructions in this article apply to Excel 2019, Excel 2016, Excel for Office 365, and Excel 2013.

How to Create a Schedule in Excel 

You can create a schedule in Excel that has the basics needed for employees, classes, or personal use. From there, add any additional features to suit your specific requirements.

Follow these steps to create a seven-day schedule with hourly blocks for a single user.

  1. Start Excel and open a new, blank workbook.

    Screenshot of starting screen in Excel
  2. Select the cell range A1:E2, then select Merge & Center in the Alignment group of the Home tab.

    Screenshot of Merge & Center
  3. Type "WEEKLY SCHEDULE" into A1:E2, change the font size to 18, and select Middle Align in the Alignment group.

    Screenshot of Middle Align in Alignment group
  4. Select cells F1:H2, select the Borders drop-down in the Font group of the Home tab, then select All Borders.

    Screenshot of Borders drop-down
  5. Enter "Daily Start Time" into F1; "Time Interval" into G1; and "Starting Date" into H1. Choose the Select All icon (between 1 and A on the worksheet), then double-click the line separating any two columns to resize all cells to fit the contents.

    Screenshot of resizing cells
  6. Select cell A3 and enter "TIME."

    Screenshot of TIME in A3
  7. Select cell A4 and enter the time you want your schedule to begin. To follow this example, enter "7:00."

    Screenshot of 7:00 in A4
  8. In cell A5, enter the next interval you want to list in the schedule. To follow this example, enter "7:30." Select A4:A5 and drag the fill handle down to fill the time increments for the rest of the day.

    Screenshot of time filled in Column A

    If you want to change the time format, select the column, right-click, then select Format Cells. Select Time in the Category list of the Number tab and choose the time format you wish to use.

  9. In cell B3, enter the day of the week with which you want your schedule to begin. To follow this example, enter "SUNDAY."

    Screenshot of SUNDAY in B3
  10. Drag the fill handle to the right to automatically fill the remaining days of the week on the schedule.

    Screenshot of filled days of the week
  11. Select Row 3. Make the font Bold and change the font size to 14.

    Screenshot of changed font in Row 3
  12. Change the font size of the times in Column A to 12.

    Screenshot of changed font size in Column A

    If necessary, select the Select All icon (between 1 and A on the worksheet) and double-click the line separating any two columns to resize all cells to fit the contents once more.

  13. Select the Select All icon or press Ctrl+A and select Center in the Alignment group of the Home tab.

    Screenshot of centered cells
  14. Select cells A1:H2. Select the Fill Color drop-down from the Font group of the Home tab and choose a fill color for the selected cells.

    Screenshot of Fill Colors
  15. Choose a unique fill color for each of the following cells or ranges:

    • A3
    • B3:H3
    • A4:A28 (or the range of cells containing times on your worksheet)
    • B4:H28 (or the range of cells making up the remainder of your schedule)
    Screenshot of fill colors for schedule

    Skip this step if you prefer a black and white schedule.

  16. Select the body of the schedule. Select the Borders drop-down in the Font group and select All Borders.

    Screenshot of All Borders in the Borders menu
  17. Save the schedule.

Save the Schedule as a Template

Saving the schedule as a template allows you to reuse it without making a new one each time or clearing the contents of your existing schedule.

  1. Select File > Export > Change File Type.

    Screenshot of Change File Type on Export tab
  2. Select Template > Save As. The Save As dialog box will open.

    Screenshot of Save As under Change File Type
  3. Open the Custom Office Templates folder.

    Screenshot of Custom Office Templates folder
  4. Enter a name for the template and select Save.

    Screenshot of Save button
  5. To use the template in the future, select the Personal tab on the New screen and select the schedule template. It will open as a new workbook.

    Screenshot of Schedule template on Personal tab

If you want to use a hardcopy version of the schedule, set up the print area before printing it out.