Template Issues

How to Display More Than 10 Events in an Excel Calendar Template

Jason MillerJason Miller Nov 13, 2026 869 views

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.

Display More Than 10 Events in an Excel Calendar Template
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.
Before you start

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.

Solution 1Recommended

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.

1
Insert the required event rows in the monthly calendar

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.

2
Copy formulas and formatting into the new rows

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.

3
Edit the MOD divisor to desired maximum events plus one

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.

4
Use the correct absolute date cell reference

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.

Increase the Event Display Limit by Changing the MOD Divisor
Events should now appear: After updating all monthly sections, events beyond the original 10 will appear as long as the event rows exist and the DataBase sheet contains matching date entries.
Fix in WPS Spreadsheets

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. 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. 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. 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. 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.
Edit Excel calendar templates directly in WPS Spreadsheets with full .xlsx formula and formatting compatibilityIncrease the event display limit by changing the MOD divisor and inserting rows in a familiar Excel-like interfaceFree to download and use, with a lightweight design that keeps template editing fastSupports Microsoft Excel files and array formulas used in calendar templates
microsoft office alternative - wps office

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.