How to Display More Than 10 Events in an Excel Calendar Template
Question details
The user needs to increase the number of events shown per day in an Excel calendar template from the default 10 to a higher number by editing the MOD divisor formula and calendar row structure.

- Product
- WPS Spreadsheets - Excel calendar template
- Device & OS
- not provided
- Scenario
- The user is managing a monthly Excel calendar template and needs to display more than 10 scheduled events on a single date.
- Observed behavior
- The template displays only up to 10 events per day because the MOD divisor is set to 11; inserting calendar rows alone does not update the event database or increase the formula limit.
Open the Excel calendar template in WPS Spreadsheets and locate the daily event area that contains the MOD formula. Have the desired maximum number of events ready so you can calculate the new divisor as that number plus one.
Increase the Event Display Limit by Changing the MOD Divisor
Use this solution when you need to show more than 10 events per day and are ready to add enough event rows in each monthly calendar.
The Excel calendar template uses a MOD divisor to create a repeating row counter. The original divisor 11 returns remainders 0 through 10, which limits the display to 10 events, so the new divisor must always be one more than the desired maximum.
In the affected month, select the existing daily event rows, right-click the selected row numbers, and choose Insert to add enough rows for the desired number of events. Repeat for each month that needs more than 10 events.
Select a row that already contains the calendar event formula, then use the fill handle or copy and paste the row to apply the same formula and formatting to every newly inserted event row.
Click the first formula cell and change the MOD function divisor from 11. For example, to display up to 13 events, change the formula to use MOD((ROW()-ROW($B$4)),14). The divisor must be 14 for 13 events.
Make sure the formula compares the event database date column to the correct absolute date reference for that calendar block, such as $B$18 or $B$68. Update the reference if your inserted rows shifted the date cell.

Troubleshoot Missing Events or January 00 Dates After Editing
Use this solution if you added rows and changed the formula, but extra events still do not appear or some cells display January 00 dates.
Edit the Excel Calendar Template Event Limit in WPS Spreadsheets
Use WPS Spreadsheets to open the Excel calendar template, insert the necessary event rows, and change the MOD divisor directly in the formula. You can display more than 10 events per day without switching to a paid Office subscription.
- 1. Open the Excel calendar template in WPS Spreadsheets: Launch WPS Office, click Open, choose the .xlsx calendar template file, and go to the monthly calendar sheet where you need more than 10 events.
- 2. Insert and populate additional event rows: Right-click the existing daily event row numbers, choose Insert, and copy the event formula plus formatting into the new rows for the affected days and months.
- 3. Update the MOD divisor in the calendar formula: Click the first event formula cell and change the MOD divisor to your desired maximum plus one. For example, use 14 to display up to 13 events, and check the date reference such as $B$18.
- 4. Save and test the calendar: Press Ctrl+S to save the workbook, enter a date with more than 10 matching events in the DataBase sheet, and verify that the extra events appear on the correct date.

Frequently Asked Questions
Why does the Excel calendar template only show 10 events per day?
The template formula uses a MOD divisor of 11, so it returns remainders 0 through 10 and can display only 10 event rows. To show more events, insert extra rows and change the MOD divisor to the desired maximum plus one.
How many rows do I need to add to display 13 events per day?
Add enough event rows so that each day can hold 13 event slots, and set the MOD divisor to 14. Repeat the row insertion and formula update for every month that needs the higher limit.
I changed the formula but extra events still do not appear. What should I check?
Check that every newly inserted row contains the same formula with the updated divisor, the divisor is one more than the desired event count, and the formula uses the correct absolute date reference such as $B$18 or $B$68.
Why do some cells show January 00 after editing the calendar formula?
January 00 usually appears when the formula returns 0 instead of empty text or when date formatting is not applied. Use IFERROR(...,"") to return blank text and apply a date format to date cells.
Do I need to add event rows to the DataBase sheet as well?
The calendar display formula reads existing events from the DataBase sheet. If the extra events are already entered there, you only need to update the calendar rows and MOD divisor. If the new events are not in the DataBase sheet, add them first.




