How to Make an Hourly Schedule on Excel

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.

...
Customize an Excel template to create an hourly schedule.

Step

Open the Microsoft Office home page.

Step

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

Step

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

Step

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

Step

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

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

Step

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

Step

Type your schedule data. Save this document.