Change Sunday to Monday in the Excel Student Schedule Template
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.
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.
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.
Open the Excel Student Schedule Template in WPS Office Excel and click the first worksheet tab where the schedule layout appears.
Find the day names in row 3, starting at cell C3.
Click C3 and type Monday, then D3 Tuesday, E3 Wednesday, and continue through Sunday in the adjacent columns.
Review the schedule area; the existing lookup formulas automatically reorganize the class entries according to the new day order.
Use Ctrl+S or Menu > Save to keep the changes, or use Save As to create a custom template.
Save the Edited Workbook as a Custom Excel Template
Use this if you want to keep the original template unchanged and reuse the Monday-start layout for future schedules.
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. Open the template in WPS Office Excel: Launch WPS Office Excel and open the Excel Student Schedule Template file.
- 2. Click the first worksheet: Select the worksheet that contains the weekly schedule layout and the day headings in row 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. Verify the schedule updates: Check that the schedule entries have re-sorted automatically according to the new Monday-first order.
- 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.

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.




