Make a Schedule in Excel Using Templates: Step by Step

How-to basics · Updated November 20, 2026

To make a schedule in Excel using a template, open File > New, search for a schedule template, select one, and choose Create. Save a copy, replace the sample dates and entries with your own, then check the schedule on screen or in print preview. You will have a ready-made layout to adapt instead of building every row and column yourself.

Excel templates vary: some are calendars, while others are designed for staff shifts, classes, or projects. The steps below apply to Microsoft Excel for Microsoft 365 on Windows. Template availability and names can vary by account and region, so choose the closest layout and adjust it to your needs.

What You’ll Need

  • Excel for Microsoft 365 on Windows, and an internet connection if you are browsing online templates.
  • A rough plan for your schedule: its date range, the people or activities to list, and the time intervals you need.
  • A folder or OneDrive location where you can save your own copy.

Step-by-Step

  1. Decide what the schedule needs to show. Before picking a design, decide whether you are scheduling employees, classes, appointments, tasks, or another activity. Note the period it should cover (such as one week or one month), whether you need times or just dates, and what details people must see. A shift schedule may need employee names, start and end times, and a role; a project schedule may need tasks, owners, due dates, and status. Having this list makes it easier to judge whether a template will work.

  2. Browse Excel’s schedule templates. In Excel for Windows, select File > New. Use the search box to look for terms such as schedule, weekly schedule, employee schedule, or calendar. Select a result to preview its layout and description, then choose Create to open a new workbook based on it. Some templates may be downloaded from Microsoft’s online gallery, so an internet connection may be required. If search results are limited, try a broader term such as calendar or planner.

  3. Save a separate working copy. Templates can contain sample data and formulas, so keep the original intact where possible. Choose File > Save As, select a folder, enter a clear filename, and save the workbook as an Excel Workbook (.xlsx). For example, use a name such as Weekly Team Schedule – April. If you save to OneDrive, confirm that you are editing your copy rather than a shared original. Saving early also gives you a recovery point if you later remove or overwrite part of the template.

  4. Inspect the workbook before replacing content. Look at every worksheet tab and scan the schedule from top to bottom. Identify which cells contain headings, sample entries, dates, formulas, or instructions. Templates may include hidden rows, pre-filled categories, or a separate key for colors. Avoid deleting entire rows or columns until you understand what they contain; a formula or chart may refer to them. If the workbook has example entries, replace the contents of those cells rather than clearing the whole sheet.

  5. Set the schedule’s dates and labels. Replace the sample title, period, names, departments, subjects, or task categories with your own. Enter dates as Excel dates rather than text where possible, so sorting and date-based formatting work correctly. Check that the first day of the week matches your needs and that the final row or column covers the full period. If the template has a date selector or instructions, follow its intended method. Keep labels short enough to fit; use clear abbreviations only when everyone who uses the schedule will understand them.

  6. Enter the actual schedule and preserve useful formatting. Fill in assignments, activities, locations, or shift times in the existing input cells. Use one consistent style for similar information, such as the same time format throughout. If you need an additional person or task, copy a suitable existing row or column and check that its formatting and formulas extend correctly. Do not assume that a blank-looking cell is unused: it might contain a formula or a formatting rule. Use Home > Clear > Clear Contents to remove unwanted sample text without automatically removing the cell’s formatting.

  7. Check calculations, readability, and printing. If the template calculates shift length, confirm that start and end times are entered as times and that the result is displayed as a number of hours or a duration as intended. For a simple shift-hours calculation, with a start time in B2 and an end time in C2, enter this in D2: =MOD(C2-B2,1)*24. For a shift from 9:00 AM to 5:30 PM, the result is 8.5 hours. The MOD version also handles an end time after midnight. Format D2 as a number if it displays as a time. Then select File > Print to review the preview, page orientation, and scaling. If columns are cut off, consider landscape orientation or adjusting scaling before printing.

  8. Save, then share the finished schedule carefully. Press Ctrl+S on Windows after your final edits. If others need access, save or move the file to a shared OneDrive or SharePoint location and use Excel’s sharing controls, or send a copy if collaboration is not required. Before sharing, check that the workbook does not contain private sample data, hidden worksheets with information you did not intend to distribute, or notes meant only for you. Tell collaborators which cells they should update and who is responsible for maintaining the schedule.

Common Mistakes

  • Choosing a template for the wrong kind of schedule: A monthly calendar can be awkward for rotating shifts, while a shift roster may be excessive for a simple list of deadlines. Check the template preview against your actual needs before entering lots of data.
  • Overwriting formulas or headings: Some templates calculate totals or use special cells for dates. Replace sample values in input areas, not formulas or labels, unless you intend to rebuild that part. If a total stops updating, undo the last change with Ctrl+Z and inspect the affected cells.
  • Entering dates or times as plain text: Text that looks like a date may not sort or calculate as one. If a date does not behave properly, re-enter it in a recognized date format and check the cell’s number format.
  • Using color as the only signal: A color-coded schedule may be difficult to interpret when printed in black and white or viewed by someone with color-vision differences. Add labels, initials, or a clear legend as well.
  • Printing without checking the page: A wide schedule may split across pages or shrink until the text is unreadable. Review Print Preview and adjust orientation, margins, or scaling before distributing paper copies.

Tips

  • Keep a clean master: Store an untouched copy of the template or a clean version of your finished schedule. Duplicate it for each new week or month so you do not have to rebuild the layout.
  • Use consistent entries: Choose one format for dates and times, and use the same spelling for repeated names or categories. Consistency makes schedules easier to scan and reduces confusion when filtering or sorting.
  • Make the schedule easy to update: Freeze headings when a sheet is long by selecting the cell below and to the right of the rows and columns you want to keep visible, then choose View > Freeze Panes. This is useful when scrolling through a large roster.
  • Keep colors meaningful: Use a small set of colors with a legend, and make sure the text remains readable. If a template already uses color to signal status, keep that meaning consistent instead of reassigning colors casually.
  • Plan for changes: Leave room for extra names or activities, and clarify whether blank cells mean available, unassigned, or not applicable. A short note at the top can prevent people from interpreting the same blank in different ways.
  • Know the Mac and web differences: On Excel for Mac, template access is commonly under File > New from Template; labels can vary by release. In Excel for the web, choose a template from the start page or use File > New where available. Some desktop template features and print settings may appear in different places online.

Troubleshooting

You cannot find a suitable template: Try a shorter, broader search such as schedule, calendar, or planner. If the gallery is empty or will not load, check your internet connection and sign-in status. You can also open a basic calendar or blank workbook and create the missing columns yourself; the benefit of a template is a starting layout, not a requirement to keep every feature.

The template opens with sample data you cannot identify: Check the worksheet tabs and read any notes or instructions. Select a sample cell and look at the formula bar to see whether it contains a value or a formula. If it is a formula, do not replace it unless you have a reason. If you have already changed something by mistake, use Ctrl+Z immediately, or reopen your saved clean copy.

Dates, totals, or shift lengths look wrong: Confirm that dates and times are stored as values, not text, and check the cell number format. For a shift that crosses midnight, use the MOD-based hours formula shown above rather than subtracting the start time directly. If a formula displays its text instead of a result, check that the cell is not formatted as Text; change it to General, then re-enter the formula.

The schedule is hard to read or does not fit on paper: Widen important columns, shorten long labels, or wrap text using Home > Wrap Text. In File > Print, check the preview and try landscape orientation or a suitable scaling option. Avoid forcing a very large sheet onto one page if that makes the printed text too small to read.

Someone cannot edit the shared file: Confirm that you shared the correct workbook and gave the person editing permission rather than view-only access. If the file is open in a read-only state, check whether it is stored in a location where you have permission to make changes, then save an editable copy if necessary.

Frequently Asked Questions

Can I make a schedule in Excel without paying for a template?

Yes. Excel includes templates that may be available at no extra cost, although access can depend on your Microsoft account and connection. You can also start with a blank workbook and create headings and date columns yourself.

Can I change an Excel schedule template after I download it?

Yes. Save a working copy, then edit its headings, dates, entries, and formatting. Keep formulas and linked cells intact if you want totals or other automatic features to keep working.

How do I make a weekly schedule instead of a monthly one?

Search for a weekly schedule template, or adapt a suitable existing layout by setting up seven days and the time or assignment rows you need. Check that the displayed date range and day names match the week you are planning.

Can I reuse the same schedule template next month?

Yes. Keep a clean master copy and use Save As to create a new file for each period. Update the dates and remove old assignments, while preserving formulas and formatting you still need.

Can several people edit the schedule?

Yes, if you store the workbook in OneDrive or SharePoint and share it with editing permission. Excel’s co-authoring availability depends on the file location, account, and app version. Agree on who updates the schedule to avoid conflicting changes.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.