Template Issues

Change Sunday to Monday in the Excel Student Schedule Template

Olivia MillerOlivia Miller Nov 13, 2026 868 views

Question details

The user needs to change the first day of the week from Sunday to Monday in the Excel Student Schedule Template and have the schedule lookups return entries in the new weekday order.

Product
WPS Office Excel - Excel Student Schedule Template
Device & OS
not provided
Scenario
The user is editing an Excel Student Schedule Template and wants the week to start on Monday instead of Sunday.
Observed behavior
The template begins the week on Sunday in row 3, and the day names drive lookup formulas that organize schedule entries.
Before you start

Open the Excel Student Schedule Template in WPS Office Excel and select the first worksheet. Make sure the row 3 day heading cells are editable before changing them.

Solution 1Recommended

Reorder the Day Headings in Row 3 to Start the Week on Monday

Use this when you want the schedule to begin on Monday without recreating the workbook or rewriting formulas.

The template's lookup formulas match entries by the day heading in row 3. Changing those headings from Sunday-first to Monday-first updates the schedule order automatically.

1
Open the first worksheet

Open the Excel Student Schedule Template in WPS Office Excel and click the first worksheet tab where the schedule layout appears.

2
Locate the day heading cells in row 3

Find the day names in row 3, starting at cell C3.

3
Enter Monday through Sunday in the desired order

Click C3 and type Monday, then D3 Tuesday, E3 Wednesday, and continue through Sunday in the adjacent columns.

4
Check the schedule results

Review the schedule area; the existing lookup formulas automatically reorganize the class entries according to the new day order.

5
Save the edited workbook

Use Ctrl+S or Menu > Save to keep the changes, or use Save As to create a custom template.

Week order updated: The schedule now starts on Monday and the lookup formulas continue to work without manual formula changes.
WPS Office Excel

Change the Excel Student Schedule Week Start to Monday in WPS Office

WPS Office Excel can open and edit the Excel Student Schedule Template directly. You only need to update the day headings in row 3, and the existing lookup formulas automatically arrange the schedule in Monday-through-Sunday order.

  1. 1. Open the template in WPS Office Excel: Launch WPS Office Excel and open the Excel Student Schedule Template file.
  2. 2. Click the first worksheet: Select the worksheet that contains the weekly schedule layout and the day headings in row 3.
  3. 3. Replace the day names in row 3: Enter Monday in C3, Tuesday in D3, Wednesday in E3, Thursday in F3, Friday in G3, Saturday in H3, and Sunday in I3.
  4. 4. Verify the schedule updates: Check that the schedule entries have re-sorted automatically according to the new Monday-first order.
  5. 5. Save or save as template: Press Ctrl+S to update the workbook, or go to Menu > Save As > Excel Template to keep a reusable Monday-start template.
Edit Excel templates without recreating formulas or schedulesMaintains full compatibility with Microsoft Excel .xlsx and .xltx filesFree WPS Office Excel works with Excel Student Schedule templatesFamiliar spreadsheet interface with easy Save As Excel Template option
microsoft office alternative - wps office

Frequently Asked Questions

Where do I change the week start in the Excel Student Schedule Template?

Open the first worksheet and change the day headings in row 3. Enter Monday in C3, Tuesday in D3, and continue through Sunday in the adjacent cells.

Do I need to edit the lookup formulas after changing the day names?

No. The formulas match by column heading, so entering the new day order in row 3 automatically re-sorts the schedule entries.

How can I keep the original Sunday-start template unchanged?

After changing the day headings, click Menu > Save As, choose Excel Template (*.xltx), and save the workbook with a new name.

Will this template still work with Microsoft Excel?

Yes. WPS Office saves the workbook in Excel-compatible formats, so the edited template can be opened in Microsoft Excel.

Can I change the schedule back to Sunday later?

Yes. Replace the row 3 headings with Sunday first again, and the formulas will reorganize the entries based on the headings.