How to Make an Hourly Schedule on Excel

By Kathryn Hatashita-Lee

The Microsoft Office website contains time-saving templates that minimize formatting. For example, the “Templates” gallery offers schedules ready for your data entry. Free, downloaded Excel templates offer the same Excel editing tools to help you customize your worksheet. Modify a template for hourly schedules by including different headers to display tasks. Change the fonts to increase readability and to reflect the workplace culture.

Step 1

Open the Microsoft Office home page.

Step 2

Type “schedule” in the “Search” text box.

Step 3

Click the radio button for “Templates.” Click "Search." A gallery of templates designed for Microsoft Office programs displays.

Step 4

Click the “Excel” link in the “Filter by” pane. Excel templates appear in the gallery.

Step 5

Click the preferred template link. Examples include “Daily-Hourly Schedule” and “Daily Schedule with Contacts and To Do.” An expanded image of the template appears.

Step 6

Click “Download.” Follow the prompts. The template appears on a new Excel page.

Step 7

Customize the template to your preferences. For example, edit the column headers.

Step 8

Type your schedule data. Save this document.

Tips & Warnings

  • Save this Excel document as an "Excel template" before typing the data. The blank schedule will be available next time.
  • Click the "Home" tab on the command ribbon to access the "Font" commands. For example, "Font Size" and "Font Color."